pgBadger-
Global information
- Generated on Mon Jul 13 23:50:13 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 51,551 log entries in 12s
- Log start from 2026-07-13 00:00:10 to 2026-07-13 23:49:55
-
Overview
Global Stats
- 424 Number of unique normalized queries
- 8,104 Number of queries
- 9h50m9s Total query duration
- 2026-07-13 00:02:15 First query
- 2026-07-13 23:49:55 Last query
- 6 queries/s at 2026-07-13 10:59:33 Query peak
- 9h50m9s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 9h50m9s Execute total duration
- 4,359 Number of events
- 19 Number of unique normalized events
- 4,071 Max number of times the same event was reported
- 0 Number of cancellation
- 541 Total number of automatic vacuums
- 1,334 Total number of automatic analyzes
- 11 Number temporary file
- 234.55 MiB Max size of temporary file
- 115.71 MiB Average size of temporary file
- 387 Total number of sessions
- 8 sessions at 2026-07-13 13:06:42 Session peak
- 13d16h1m14s Total duration of sessions
- 50m51s Average duration of sessions
- 20 Average queries per session
- 1m31s Average queries duration per session
- 49m19s Average idle time per session
- 395 Total number of connections
- 5 connections/s at 2026-07-13 03:05:17 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 6 queries/s Query Peak
- 2026-07-13 10:59:33 Date
SELECT Traffic
Key values
- 5 queries/s Query Peak
- 2026-07-13 10:59:33 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 4 queries/s Query Peak
- 2026-07-13 23:49:24 Date
Queries duration
Key values
- 9h50m9s 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 13 00 23 0ms 21s942ms 5s413ms 4s302ms 17s513ms 1m5s 01 11 0ms 4s821ms 2s377ms 3s450ms 4s601ms 5s127ms 02 12 0ms 4s253ms 2s146ms 3s741ms 4s404ms 4s675ms 03 14 0ms 4s600ms 1s845ms 3s343ms 4s298ms 5s443ms 04 11 0ms 4s586ms 2s276ms 3s385ms 4s385ms 4s772ms 05 17 0ms 9m19s 1m6s 4s692ms 2m31s 9m19s 06 27 0ms 11s392ms 2s637ms 3s660ms 4s469ms 33s200ms 07 207 0ms 13m8s 11s682ms 49s599ms 4m31s 13m8s 08 631 150ms 6m47s 4s154ms 1m3s 4m57s 7m3s 09 755 150ms 13m39s 3s298ms 54s280ms 2m5s 18m41s 10 822 150ms 10m30s 2s534ms 53s934ms 2m2s 11m 11 814 150ms 9m6s 3s258ms 1m4s 5m13s 11m5s 12 288 0ms 9m11s 7s272ms 50s351ms 5m10s 9m49s 13 628 150ms 6m36s 2s356ms 42s253ms 2m4s 6m48s 14 953 150ms 10m35s 2s734ms 56s197ms 5m19s 10m50s 15 980 150ms 10m46s 3s556ms 2m37s 7m27s 11m17s 16 735 150ms 12m3s 4s174ms 44s770ms 8m16s 12m15s 17 614 0ms 13m50s 3s747ms 1m21s 2m17s 14m16s 18 26 0ms 7m29s 28s462ms 4s775ms 52s172ms 7m29s 19 21 0ms 5m55s 30s922ms 5s195ms 50s94ms 5m55s 20 123 0ms 11m11s 13s359ms 1m15s 1m37s 11m11s 21 30 0ms 6m15s 21s438ms 4s761ms 15s704ms 6m45s 22 21 0ms 5m45s 29s362ms 4s547ms 43s371ms 5m45s 23 341 0ms 1m44s 6s990ms 1m15s 1m25s 1m44s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 13 00 5 0 3s646ms 0ms 0ms 718ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 1 0 254ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 11 0 1s619ms 0ms 0ms 2s86ms 07 148 0 13s683ms 4s264ms 39s592ms 7m10s 08 457 0 4s761ms 16s383ms 1m3s 6m50s 09 575 0 3s651ms 11s850ms 20s860ms 5m55s 10 656 0 2s597ms 14s504ms 42s511ms 5m15s 11 621 0 3s290ms 14s525ms 54s295ms 8m8s 12 211 0 9s93ms 6s886ms 18s944ms 7m45s 13 483 0 2s466ms 11s607ms 24s772ms 3m56s 14 737 0 3s56ms 15s822ms 22s869ms 8m39s 15 747 0 3s740ms 21s877ms 1m58s 7m43s 16 591 0 4s787ms 16s299ms 44s323ms 9m16s 17 453 0 4s202ms 18s609ms 40s197ms 5m12s 18 10 0 1m10s 0ms 0ms 3m23s 19 6 0 1m42s 0ms 0ms 3m31s 20 22 86 14s721ms 26s644ms 1m8s 4m15s 21 14 0 43s777ms 0ms 202ms 3m10s 22 7 0 1m23s 0ms 0ms 3m17s 23 12 329 6s990ms 1m5s 1m15s 1m44s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 13 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 13 00 0 1 1.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 1 1.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 1 1.00 0.00% 07 0 13 13.00 0.00% 08 0 16 16.00 0.00% 09 0 20 20.00 0.00% 10 0 14 14.00 0.00% 11 0 11 11.00 0.00% 12 0 10 10.00 0.00% 13 0 17 17.00 0.00% 14 0 14 14.00 0.00% 15 0 14 14.00 0.00% 16 0 14 14.00 0.00% 17 0 15 15.00 0.00% 18 0 1 1.00 0.00% 19 0 0 0.00 0.00% 20 0 2 2.00 0.00% 21 0 1 1.00 0.00% 22 0 0 0.00 0.00% 23 0 1 1.00 0.00% Day Hour Count Average / Second Jul 13 00 16 0.00/s 01 8 0.00/s 02 7 0.00/s 03 17 0.00/s 04 7 0.00/s 05 8 0.00/s 06 14 0.00/s 07 16 0.00/s 08 24 0.01/s 09 24 0.01/s 10 22 0.01/s 11 21 0.01/s 12 15 0.00/s 13 23 0.01/s 14 23 0.01/s 15 21 0.01/s 16 26 0.01/s 17 26 0.01/s 18 24 0.01/s 19 9 0.00/s 20 15 0.00/s 21 11 0.00/s 22 9 0.00/s 23 9 0.00/s Day Hour Count Average Duration Average idle time Jul 13 00 3 43m20s 42m39s 01 14 1h1m17s 1h1m15s 02 8 1h23s 1h19s 03 15 20m48s 20m47s 04 7 1h3m 1h2m56s 05 7 1h12s 57m30s 06 8 59m22s 59m13s 07 14 58m 55m8s 08 19 51m38s 49m20s 09 23 53m12s 51m24s 10 22 58m12s 56m37s 11 23 53m34s 51m39s 12 21 54m21s 52m42s 13 14 53m42s 51m57s 14 25 54m38s 52m53s 15 23 54m57s 52m25s 16 23 48m19s 46m6s 17 30 43m47s 42m30s 18 30 33m21s 32m57s 19 12 56m1s 55m7s 20 11 44m28s 41m58s 21 12 55m50s 54m57s 22 11 1h48s 59m52s 23 12 48m19s 45m1s -
Connections
Established Connections
Key values
- 5 connections Connection Peak
- 2026-07-13 03:05:17 Date
Connections per database
Key values
- rio Main Database
- 395 connections Total
Connections per user
Key values
- intelifix Main User
- 395 connections Total
-
Sessions
Simultaneous sessions
Key values
- 8 sessions Session Peak
- 2026-07-13 13:06:42 Date
Histogram of session times
Key values
- 296 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 387 sessions Total
Sessions per user
Key values
- intelifix Main User
- 387 sessions Total
Sessions per host
Key values
- [local] Main Host
- 387 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 16,036 buffers Checkpoint Peak
- 2026-07-13 15:49:39 Date
- 269.998 seconds Highest write time
- 0.133 seconds Sync time
Checkpoints Wal files
Key values
- 10 files Wal files usage Peak
- 2026-07-13 15:29:39 Date
Checkpoints distance
Key values
- 317.85 Mo Distance Peak
- 2026-07-13 15:29:39 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jul 13 00 4,598 269.907s 0.008s 269.924s 01 0 0s 0s 0s 02 0 0s 0s 0s 03 10,899 0.662s 0.018s 0.699s 04 0 0s 0s 0s 05 6,412 643.013s 0.063s 643.13s 06 3,733 374.487s 0.013s 374.526s 07 25,998 2,011.018s 0.196s 2,011.324s 08 72,441 3,238.548s 0.672s 3,239.469s 09 53,003 3,238.899s 0.663s 3,239.799s 10 62,284 3,238.773s 0.68s 3,239.705s 11 65,282 3,238.711s 0.678s 3,239.635s 12 36,015 2,151.694s 0.242s 2,152.08s 13 32,468 2,480.046s 0.637s 2,480.864s 14 72,045 3,238.514s 0.84s 3,239.646s 15 94,459 3,238.536s 0.806s 3,239.595s 16 61,385 3,238.722s 0.753s 3,239.695s 17 57,893 2,573.995s 0.553s 2,574.767s 18 1,292 129.944s 0.033s 130.03s 19 347 35.181s 0.032s 35.272s 20 1,830 320.785s 0.067s 320.907s 21 3,019 303.466s 0.033s 303.571s 22 2,243 225.324s 0.028s 225.408s 23 4,297 289.759s 0.018s 289.822s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jul 13 00 0 0 1 28 0.001s 0.001s 01 0 0 0 0 0s 0s 02 0 0 0 0 0s 0s 03 0 0 4 35 0.011s 0.002s 04 0 0 0 0 0s 0s 05 0 0 3 132 0.030s 0.007s 06 0 0 0 81 0.003s 0.003s 07 0 0 18 1,999 0.018s 0.012s 08 0 0 42 6,135 0.017s 0.012s 09 0 0 29 7,731 0.012s 0.012s 10 0 0 31 7,887 0.013s 0.012s 11 0 0 37 7,643 0.005s 0.012s 12 0 0 22 3,649 0.008s 0.012s 13 0 0 15 6,378 0.035s 0.012s 14 0 0 39 8,106 0.009s 0.012s 15 0 0 59 7,979 0.012s 0.012s 16 0 0 28 6,720 0.023s 0.012s 17 0 0 39 5,966 0.008s 0.011s 18 0 0 0 431 0.003s 0.009s 19 0 0 0 268 0.006s 0.007s 20 0 0 1 341 0.017s 0.009s 21 0 0 1 508 0.003s 0.009s 22 0 0 1 436 0.003s 0.008s 23 0 0 2 27 0.003s 0.005s Day Hour Count Avg time (sec) Jul 13 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 13 00 23,443.00 kB 23,443.00 kB 01 0.00 kB 0.00 kB 02 0.00 kB 0.00 kB 03 31,219.50 kB 31,219.50 kB 04 0.00 kB 0.00 kB 05 6,761.83 kB 9,878.67 kB 06 3,960.00 kB 10,224.67 kB 07 23,868.25 kB 51,143.75 kB 08 57,498.58 kB 92,930.33 kB 09 39,728.08 kB 83,025.42 kB 10 41,771.08 kB 89,071.00 kB 11 51,428.25 kB 85,465.50 kB 12 28,941.25 kB 75,173.42 kB 13 20,946.75 kB 45,657.50 kB 14 53,492.75 kB 76,152.83 kB 15 80,208.42 kB 124,007.75 kB 16 38,759.25 kB 81,051.58 kB 17 57,431.91 kB 95,213.00 kB 18 619.00 kB 51,684.89 kB 19 197.71 kB 22,081.86 kB 20 2,129.38 kB 11,254.25 kB 21 1,731.50 kB 5,410.88 kB 22 1,501.12 kB 3,300.12 kB 23 8,375.40 kB 16,218.60 kB -
Temporary Files
Size of temporary files
Key values
- 469.11 MiB Temp Files size Peak
- 2026-07-13 05:32:02 Date
Number of temporary files
Key values
- 2 per second Temp Files Peak
- 2026-07-13 05:32:02 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jul 13 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 10 1.07 GiB 109.07 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 1 182.04 MiB 182.04 MiB 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 8 911.39 MiB 69.96 MiB 234.55 MiB 113.92 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-13 05:32:09 Duration: 1m28s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-13 05:32:02 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 2 179.33 MiB 89.66 MiB 89.66 MiB 89.66 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-13 05:30:41 Duration: 39s572ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-13 05:30:38 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
3 1 182.04 MiB 182.04 MiB 182.04 MiB 182.04 MiB select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel (?);-
SELECT RS_SETGLOBAL ('USUARIO', 416); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01527);
Date: 2026-07-13 13:13:54 Duration: 1m52s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT RS_SETGLOBAL ('USUARIO', 398); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (04375);
Date: 2026-07-13 08:03:28 Duration: 20s531ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT RS_SETGLOBAL ('USUARIO', 398); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (04384);
Date: 2026-07-13 17:02:28 Duration: 17s889ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
Queries generating the largest temporary files
Rank Size Query 1 234.55 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-13 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 234.55 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-13 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 182.04 MiB SELECT RS_SETGLOBAL ('USUARIO', 416); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01527);[ Date: 2026-07-13 13:13:43 - Database: contagem - User: intelifix - Remote: [local] - Application: psql ]
4 89.66 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-07-13 05:30:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 89.66 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-07-13 05:30:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 77.49 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-13 05:32:09 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 77.42 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-13 05:32:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 77.41 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-13 05:32:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 70.03 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-13 05:32:09 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 69.97 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-13 05:32:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 69.96 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-13 05:32:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 14.56 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_07
Database rio - 2026-07-13 10:17:46 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 14.56 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_07
Database rio - 2026-07-13 10:17:46 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (135) Main table analyzed (database rio)
- 1,334 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 135 contagem.public.temp0000226614 85 rio.pg_catalog.pg_class 69 contagem.pg_catalog.pg_attribute 59 rio.pg_catalog.pg_type 58 brasilia.pg_catalog.pg_attribute 50 rio.public.usuarios 49 contagem.pg_catalog.pg_class 48 rio.public.temp0000285112 44 contagem.pg_catalog.pg_type 40 rio.pg_catalog.pg_index 35 rio.public.temp0000285180 34 rio.public.temp0000285120 32 rio.public.temp0000285186 31 brasilia.pg_catalog.pg_class 27 rio.pg_catalog.pg_depend 27 contagem.pg_catalog.pg_index 25 brasilia.pg_catalog.pg_type 24 rio.public.temp0000285110 23 contagem.pg_catalog.pg_depend 20 brasilia.public.temp0000235936 18 rio.public.temp0000285164 18 brasilia.pg_catalog.pg_index 17 rio.public.temp0000284996 17 contagem.public.usuarios 16 rio.public.temp0000284664 16 rio.public.temp0000284750 14 brasilia.pg_catalog.pg_depend 14 rio.public.temp0000285020 13 brasilia.public.temp0000235980 12 rio.public.temp0000285216 12 rio.public.temp0000285132 12 rio.public.temp0000285116 12 rio.public.temp0000285104 12 contagem.public.temp0000226610 11 brasilia.public.usuarios 10 rio.public.temp0000284762 10 rio.public.temp0000285130 9 rio.public.temp0000285142 9 rio.public.temp0000285190 9 contagem.public.temp0000226612 7 rio.public.temp0000285200 7 contagem.public.temp0000226618 7 rio.public.temp0000285146 6 rio.public.temp0000285114 6 rio.public.temp0000285168 6 rio.public.temp0000285198 5 rio.public.temp0000285196 5 brasilia.public.nf_entrada 5 brasilia.public.temp0000235934 5 brasilia.public.temp0000235988 5 brasilia.public.temp0000236002 5 contagem.public.temp0000226616 5 postgres.pg_catalog.pg_shdepend 5 rio.public.temp0000285222 4 rio.public.temp0000285210 4 contagem.public.nf_entrada 4 rio.public.temp0000285144 4 rio.public.temp0000285204 4 rio.public.temp0000285220 4 brasilia.pg_catalog.pg_shdepend 4 rio.public.temp0000285148 3 rio.public.temp0000285158 3 rio.pg_catalog.pg_shdepend 3 contagem.pg_catalog.pg_shdepend 3 rio.public.temp0000285128 3 template1.pg_catalog.pg_shdepend 2 contagem.public.parametros 2 brasilia.public.temp0000235978 2 brasilia.public.temp0000235938 2 rio.public.temp0000285192 2 rio.public.temp0000285134 2 brasilia.public.temp0000235930 2 brasilia.public.temp0000235962 2 brasilia.public.temp0000235944 2 rio.public.temp0000285188 2 rio.public.temp0000285184 1 brasilia.public.temp0000235958 1 rio.public.temp0000285126 1 brasilia.public.temp0000235932 1 brasilia.public.temp0000236006 1 brasilia.public.temp0000235960 1 brasilia.public.temp0000235982 1 brasilia.auditor.auditor_2026_07 1 brasilia.public.temp0000235948 1 brasilia.public.temp0000235950 1 brasilia.public.temp0000235940 1 rio.public.temp0000285156 1 rio.public.tmp_drill_0302 1 brasilia.public.temp0000235986 1 rio.public.temp0000285166 1 brasilia.public.temp0000235990 1 Total 1,334 Vacuums per table
Key values
- pg_catalog.pg_attribute (54) Main table vacuumed on database rio
- 541 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 54 44 0 0 0 0 0 24,420 6,585 9,716,696 368 8,988 rio.public.temp0000285112 43 0 0 0 0 0 0 27,505 3,731 6,346,256 0 0 rio.pg_catalog.pg_class 31 22 0 0 0 0 0 4,299 1,541 2,208,330 86 336 rio.pg_catalog.pg_type 28 20 0 0 0 0 0 2,214 757 1,033,893 84 302 rio.public.temp0000285186 27 0 0 0 0 0 0 3,017 305 474,237 0 0 contagem.pg_catalog.pg_attribute 22 22 0 0 0 0 0 12,487 3,195 5,855,030 26 755 brasilia.pg_catalog.pg_attribute 19 19 0 0 0 0 0 10,155 2,244 3,890,377 85 2,427 rio.public.temp0000284996 16 0 0 0 0 0 0 967 91 70,605 0 0 contagem.public.usuarios 16 0 0 0 0 0 0 73 53 27,730 1 1 rio.public.temp0000284664 15 0 0 0 0 0 0 752 86 57,038 0 0 contagem.pg_catalog.pg_class 15 15 0 0 0 0 0 2,716 782 1,154,193 14 40 contagem.pg_catalog.pg_type 13 13 0 0 0 0 0 1,261 397 609,342 11 21 brasilia.pg_catalog.pg_class 13 13 0 0 0 0 0 2,668 492 863,853 28 90 rio.public.temp0000285020 13 0 0 0 0 0 0 700 210 283,602 0 0 rio.public.temp0000284750 12 0 0 0 0 0 0 836 105 114,135 0 0 brasilia.pg_catalog.pg_type 11 11 0 0 0 0 0 1,093 207 319,511 22 56 rio.pg_catalog.pg_index 11 11 0 0 0 0 0 690 174 191,887 33 76 rio.public.temp0000284762 10 0 0 0 0 0 0 543 192 271,515 0 0 rio.public.usuarios 10 5 0 0 0 0 0 151 61 122,248 5 7 rio.pg_catalog.pg_depend 9 9 0 0 0 0 0 2,519 920 1,250,834 59 528 contagem.pg_catalog.pg_index 9 9 0 0 0 0 0 434 156 138,495 10 11 rio.pg_catalog.pg_statistic 9 9 0 0 0 0 0 10,658 2,530 11,772,551 996 4,220 contagem.pg_catalog.pg_depend 8 8 0 0 0 0 0 2,007 643 1,282,297 5 30 template1.pg_catalog.pg_shdepend 8 8 0 0 0 0 0 1,388 448 925,521 98 252 contagem.public.temp0000226618 7 0 0 0 0 0 0 730 42 49,682 0 0 rio.public.temp0000285164 7 0 0 0 0 0 0 1,925 28 117,892 0 0 brasilia.pg_catalog.pg_index 7 7 0 0 0 0 0 394 84 82,941 21 40 rio.public.temp0000285216 6 0 0 0 0 0 0 315 31 23,561 0 0 rio.public.temp0000285200 6 0 0 0 0 0 0 8,239 1,666 2,596,726 0 0 rio.public.temp0000285168 5 0 0 0 0 0 0 3,304 17 197,756 0 0 brasilia.public.temp0000235934 5 0 0 0 0 0 0 1,200 30 76,437 0 0 brasilia.public.temp0000236002 5 0 0 0 0 0 0 970 261 424,933 0 0 brasilia.pg_catalog.pg_depend 5 5 0 0 0 0 0 1,451 374 628,553 22 182 contagem.pg_catalog.pg_statistic 5 5 0 0 0 0 0 4,968 855 3,455,539 418 2,531 contagem.public.temp0000226610 4 0 0 0 0 0 0 318 215 343,946 0 0 rio.public.temp0000285220 4 0 0 0 0 0 0 6,592 1,660 2,500,663 0 0 rio.pg_toast.pg_toast_2619 4 4 0 0 0 0 0 1,866 385 2,015,169 109 298 rio.public.temp0000285210 4 0 0 0 0 0 0 1,660 13 100,157 0 0 rio.public.temp0000285222 4 0 0 0 0 0 0 3,304 1,658 2,305,920 0 0 brasilia.pg_catalog.pg_statistic 3 3 0 0 0 0 0 4,034 510 2,179,962 280 2,185 postgres.pg_catalog.pg_shdepend 2 2 0 0 0 0 0 345 86 219,575 3 3 rio.public.temp0000285188 2 0 0 0 0 0 0 186 12 12,801 0 0 rio.public.temp0000285192 2 0 0 0 0 0 0 1,652 7 98,609 0 0 rio.public.temp0000285158 2 0 0 0 0 0 0 3,292 8 195,434 0 0 brasilia.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 291 47 287,707 21 71 contagem.public.nf_entrada 2 2 0 0 0 0 0 207 81 141,514 9 20 rio.public.temp0000285134 2 0 0 0 0 0 0 74 11 6,032 0 0 contagem.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 201 49 194,653 14 36 rio.public.temp0000285128 1 0 0 0 0 0 0 66 6 4,768 0 0 brasilia.public.temp0000235986 1 0 0 0 0 0 0 240 6 15,290 0 0 contagem.auditor.auditor_2026_07 1 0 0 0 0 0 0 15,049 8,520 11,819,099 3,219 71,028 rio.auditor.auditor_2026_07 1 0 0 0 0 0 0 63,286 40,470 52,228,006 11,374 224,237 rio.public.temp0000285130 1 0 0 0 0 0 0 66 6 4,768 0 0 rio.public.notas_fiscais 1 0 0 0 0 0 0 22 20 73,531 1 185 rio.public.temp0000285190 1 0 0 0 0 0 0 67 4 4,556 0 0 brasilia.auditor.auditor_2026_07 1 0 0 0 0 0 0 27,877 14,596 19,354,994 6,654 145,617 brasilia.public.temp0000235990 1 0 0 0 0 0 0 240 6 15,288 0 0 brasilia.public.temp0000235982 1 0 0 0 0 0 0 240 239 379,151 0 0 rio.public.temp0000285196 1 0 0 0 0 0 0 68 4 4,615 0 0 brasilia.public.temp0000235960 1 0 0 0 0 0 0 240 6 15,290 0 0 rio.public.temp0000285146 1 0 0 0 0 0 0 67 6 4,828 0 0 rio.public.temp0000285156 1 0 0 0 0 0 0 4 3 774 0 0 rio.public.tmp_drill_0302 1 1 0 0 0 0 0 40 3 9,723 0 0 contagem.public.fluxos 1 1 0 0 0 0 0 7,576 3,781 11,439,428 272 12,504 brasilia.public.nf_entrada 1 1 0 0 0 0 0 185 21 84,355 1 2 brasilia.public.nf_entrada_arquivo_erros 1 0 0 0 0 0 0 332 150 458,190 73 3,451 rio.public.temp0000285132 1 0 0 0 0 0 0 8 5 1,264 0 0 rio.public.temp0000285148 1 0 0 0 0 0 0 8 5 1,265 0 0 rio.pg_toast.pg_toast_365051 1 0 0 0 0 0 0 763 261 1,761,005 252 1,072 rio.public.temp0000285198 1 0 0 0 0 0 0 76 6 5,377 0 0 Total 541 273 0 0 0 0 0 277,591 102,159 164,921,903 24,674 481,602 Vacuum throughput per table
Key values
- auditor.auditor_2026_07 (14.56) Max CPU elapsed for vacuum on database rio
- unknown (0 ms) Max I/O read time for vacuum on database rio
- unknown (0 ms) Max I/O write time for vacuum on database rio
I/O timing (ms) CPU (s) Table read write elapsed rio.pg_catalog.pg_attribute 0 0 4.12 rio.public.temp0000285112 0 0 1.44 rio.pg_catalog.pg_class 0 0 1.34 rio.pg_catalog.pg_type 0 0 0.56 rio.public.temp0000285186 0 0 0.45 contagem.pg_catalog.pg_attribute 0 0 1.76 brasilia.pg_catalog.pg_attribute 0 0 1.37 rio.public.temp0000284996 0 0 0.22 contagem.public.usuarios 0 0 0.01 rio.public.temp0000284664 0 0 0.22 contagem.pg_catalog.pg_class 0 0 0.59 contagem.pg_catalog.pg_type 0 0 0.28 brasilia.pg_catalog.pg_class 0 0 0.33 rio.public.temp0000285020 0 0 0.2 rio.public.temp0000284750 0 0 0.16 brasilia.pg_catalog.pg_type 0 0 0.14 rio.pg_catalog.pg_index 0 0 0.33 rio.public.temp0000284762 0 0 0.16 rio.public.usuarios 0 0 0.02 rio.pg_catalog.pg_depend 0 0 0.71 contagem.pg_catalog.pg_index 0 0 0.33 rio.pg_catalog.pg_statistic 0 0 1.92 contagem.pg_catalog.pg_depend 0 0 0.51 template1.pg_catalog.pg_shdepend 0 0 0.58 contagem.public.temp0000226618 0 0 0.11 rio.public.temp0000285164 0 0 0.06 brasilia.pg_catalog.pg_index 0 0 0.09 rio.public.temp0000285216 0 0 0.14 rio.public.temp0000285200 0 0 0.35 rio.public.temp0000285168 0 0 0.21 brasilia.public.temp0000235934 0 0 0.08 brasilia.public.temp0000236002 0 0 0.11 brasilia.pg_catalog.pg_depend 0 0 0.46 contagem.pg_catalog.pg_statistic 0 0 0.84 contagem.public.temp0000226610 0 0 0.07 rio.public.temp0000285220 0 0 0.22 rio.pg_toast.pg_toast_2619 0 0 0.27 rio.public.temp0000285210 0 0 0.18 rio.public.temp0000285222 0 0 0.24 brasilia.pg_catalog.pg_statistic 0 0 0.35 postgres.pg_catalog.pg_shdepend 0 0 0.11 rio.public.temp0000285188 0 0 0.02 rio.public.temp0000285192 0 0 0.1 rio.public.temp0000285158 0 0 0.1 brasilia.pg_toast.pg_toast_2619 0 0 0.04 contagem.public.nf_entrada 0 0 0.05 rio.public.temp0000285134 0 0 0.02 contagem.pg_toast.pg_toast_2619 0 0 0.03 rio.public.temp0000285128 0 0 0.02 brasilia.public.temp0000235986 0 0 0.03 contagem.auditor.auditor_2026_07 0 0 3.66 rio.auditor.auditor_2026_07 0 0 14.56 rio.public.temp0000285130 0 0 0.01 rio.public.notas_fiscais 0 0 0.11 rio.public.temp0000285190 0 0 0 brasilia.auditor.auditor_2026_07 0 0 5.27 brasilia.public.temp0000235990 0 0 0.02 brasilia.public.temp0000235982 0 0 0.03 rio.public.temp0000285196 0 0 0 brasilia.public.temp0000235960 0 0 0.02 rio.public.temp0000285146 0 0 0.01 rio.public.temp0000285156 0 0 0.04 rio.public.tmp_drill_0302 0 0 0 contagem.public.fluxos 0 0 2.13 brasilia.public.nf_entrada 0 0 0.03 brasilia.public.nf_entrada_arquivo_erros 0 0 0.13 rio.public.temp0000285132 0 0 0.02 rio.public.temp0000285148 0 0 0.01 rio.pg_toast.pg_toast_365051 0 0 0.17 rio.public.temp0000285198 0 0 0.02 Total 0 0 48.29 Tuples removed per table
Key values
- pg_catalog.pg_attribute (181964) Main table with removed tuples on database rio
- 469208 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 54 44 181,964 1,337,690 93,575 189 32,128 brasilia.pg_catalog.pg_attribute 19 19 90,781 429,232 1,353 178 10,711 contagem.pg_catalog.pg_attribute 22 22 81,565 520,807 68 191 11,827 rio.pg_catalog.pg_statistic 9 9 15,022 76,585 1,060 0 11,574 contagem.public.fluxos 1 1 10,695 418,613 0 0 5,229 rio.pg_catalog.pg_depend 9 9 9,899 171,519 810 0 1,683 contagem.pg_catalog.pg_statistic 5 5 8,814 38,844 0 0 5,055 brasilia.pg_catalog.pg_statistic 3 3 6,355 23,601 0 0 3,216 template1.pg_catalog.pg_shdepend 8 8 6,274 109,430 813 0 920 rio.pg_catalog.pg_type 28 20 5,922 68,700 5,118 4 1,991 contagem.pg_catalog.pg_depend 8 8 5,661 145,254 12 0 1,388 brasilia.pg_catalog.pg_depend 5 5 5,587 82,279 42 0 935 brasilia.pg_catalog.pg_type 11 11 5,338 24,489 2 0 769 brasilia.pg_catalog.pg_class 13 13 4,314 46,675 4 33 1,675 rio.pg_catalog.pg_class 31 22 4,214 122,643 14,175 71 3,891 contagem.pg_catalog.pg_type 13 13 3,597 29,235 4 14 841 contagem.pg_catalog.pg_class 15 15 3,551 54,848 68 21 1,956 rio.pg_catalog.pg_index 11 11 3,113 21,256 120 0 627 brasilia.public.nf_entrada 1 1 2,833 4,735 0 0 152 brasilia.pg_catalog.pg_index 7 7 2,458 13,180 0 8 378 brasilia.auditor.auditor_2026_07 1 0 1,923 2,057,351 0 0 90,105 postgres.pg_catalog.pg_shdepend 2 2 1,904 27,217 0 0 230 rio.auditor.auditor_2026_07 1 0 1,559 8,170,019 0 0 377,911 brasilia.public.nf_entrada_arquivo_erros 1 0 1,320 1,658,071 0 0 29,737 contagem.pg_catalog.pg_index 9 9 1,280 17,074 2 18 439 rio.pg_toast.pg_toast_2619 4 4 1,127 2,313 0 0 1,024 contagem.public.usuarios 16 0 975 368 0 0 32 contagem.public.nf_entrada 2 2 600 2,456 0 0 138 rio.public.usuarios 10 5 273 6,420 1,330 0 170 brasilia.pg_toast.pg_toast_2619 2 2 161 273 0 18 87 contagem.pg_toast.pg_toast_2619 2 2 128 234 0 20 66 rio.public.notas_fiscais 1 0 1 173,889 0 0 943 rio.public.temp0000285168 5 0 0 115,788 0 0 8,320 rio.public.temp0000285128 1 0 0 1,173 0 6 58 rio.public.temp0000284996 16 0 0 47,067 0 474 1,062 contagem.public.temp0000226618 7 0 0 8,760 0 224 672 brasilia.public.temp0000235986 1 0 0 3,097 0 24 232 brasilia.public.temp0000235934 5 0 0 15,475 0 120 1,160 contagem.auditor.auditor_2026_07 1 0 0 1,283,364 0 0 53,205 rio.public.temp0000285188 2 0 0 7,571 0 86 170 rio.public.temp0000285130 1 0 0 1,173 0 6 58 brasilia.public.temp0000236002 5 0 0 15,499 0 117 1,163 contagem.public.temp0000226610 4 0 0 4,994 0 131 381 rio.public.temp0000284664 15 0 0 40,403 0 498 910 rio.public.temp0000285190 1 0 0 1,263 0 0 64 rio.public.temp0000285192 2 0 0 46,364 0 0 3,328 rio.public.temp0000284762 10 0 0 33,958 0 386 766 brasilia.public.temp0000235990 1 0 0 3,096 0 24 232 brasilia.public.temp0000235982 1 0 0 3,096 0 24 232 rio.public.temp0000285196 1 0 0 1,263 0 0 64 rio.public.temp0000285220 4 0 0 92,742 0 0 6,656 brasilia.public.temp0000235960 1 0 0 3,097 0 24 232 rio.public.temp0000285146 1 0 0 1,174 0 5 59 rio.public.temp0000285156 1 0 0 23,156 0 0 1,664 rio.public.temp0000285164 7 0 0 34,630 0 15 2,033 rio.public.tmp_drill_0302 1 1 0 548 0 0 15 rio.public.temp0000285158 2 0 0 46,312 0 0 3,328 rio.public.temp0000285216 6 0 0 39,242 0 199 2,105 rio.public.temp0000285200 6 0 0 139,012 0 0 9,984 rio.public.temp0000285132 1 0 0 1,174 0 6 58 rio.public.temp0000285112 43 0 0 579,048 0 505 41,095 rio.public.temp0000285186 27 0 0 111,069 0 1,409 5,119 rio.public.temp0000285148 1 0 0 1,174 0 5 59 rio.public.temp0000285134 2 0 0 2,348 0 12 116 rio.pg_toast.pg_toast_365051 1 0 0 171,318 0 0 38,215 rio.public.temp0000285210 4 0 0 92,713 0 0 6,656 rio.public.temp0000285222 4 0 0 92,735 0 0 6,656 rio.public.temp0000284750 12 0 0 35,744 0 427 789 rio.public.temp0000285198 1 0 0 1,328 0 60 68 rio.public.temp0000285020 13 0 0 35,614 0 382 802 Total 541 273 469,208 18,992,882 118,556 5,934 795,614 Pages removed per table
Key values
- public.temp0000285186 (1409) Main table with removed pages on database rio
- 5934 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.public.temp0000285186 27 0 0 1409 rio.public.temp0000285112 43 0 0 505 rio.public.temp0000284664 15 0 0 498 rio.public.temp0000284996 16 0 0 474 rio.public.temp0000284750 12 0 0 427 rio.public.temp0000284762 10 0 0 386 rio.public.temp0000285020 13 0 0 382 contagem.public.temp0000226618 7 0 0 224 rio.public.temp0000285216 6 0 0 199 contagem.pg_catalog.pg_attribute 22 22 81565 191 rio.pg_catalog.pg_attribute 54 44 181964 189 brasilia.pg_catalog.pg_attribute 19 19 90781 178 contagem.public.temp0000226610 4 0 0 131 brasilia.public.temp0000235934 5 0 0 120 brasilia.public.temp0000236002 5 0 0 117 rio.public.temp0000285188 2 0 0 86 rio.pg_catalog.pg_class 31 22 4214 71 rio.public.temp0000285198 1 0 0 60 brasilia.pg_catalog.pg_class 13 13 4314 33 brasilia.public.temp0000235986 1 0 0 24 brasilia.public.temp0000235990 1 0 0 24 brasilia.public.temp0000235982 1 0 0 24 brasilia.public.temp0000235960 1 0 0 24 contagem.pg_catalog.pg_class 15 15 3551 21 contagem.pg_toast.pg_toast_2619 2 2 128 20 contagem.pg_catalog.pg_index 9 9 1280 18 brasilia.pg_toast.pg_toast_2619 2 2 161 18 rio.public.temp0000285164 7 0 0 15 contagem.pg_catalog.pg_type 13 13 3597 14 rio.public.temp0000285134 2 0 0 12 brasilia.pg_catalog.pg_index 7 7 2458 8 rio.public.temp0000285128 1 0 0 6 rio.public.temp0000285130 1 0 0 6 rio.public.temp0000285132 1 0 0 6 rio.public.temp0000285146 1 0 0 5 rio.public.temp0000285148 1 0 0 5 rio.pg_catalog.pg_type 28 20 5922 4 rio.public.temp0000285168 5 0 0 0 postgres.pg_catalog.pg_shdepend 2 2 1904 0 contagem.auditor.auditor_2026_07 1 0 0 0 rio.auditor.auditor_2026_07 1 0 1559 0 rio.public.notas_fiscais 1 0 1 0 rio.pg_catalog.pg_depend 9 9 9899 0 rio.public.temp0000285190 1 0 0 0 brasilia.pg_catalog.pg_type 11 11 5338 0 rio.public.temp0000285192 2 0 0 0 brasilia.auditor.auditor_2026_07 1 0 1923 0 rio.public.temp0000285196 1 0 0 0 rio.public.temp0000285220 4 0 0 0 brasilia.pg_catalog.pg_depend 5 5 5587 0 rio.public.temp0000285156 1 0 0 0 rio.pg_catalog.pg_statistic 9 9 15022 0 brasilia.pg_catalog.pg_statistic 3 3 6355 0 rio.public.tmp_drill_0302 1 1 0 0 contagem.public.fluxos 1 1 10695 0 rio.public.temp0000285158 2 0 0 0 brasilia.public.nf_entrada 1 1 2833 0 brasilia.public.nf_entrada_arquivo_erros 1 0 1320 0 contagem.public.nf_entrada 2 2 600 0 rio.public.temp0000285200 6 0 0 0 rio.pg_toast.pg_toast_2619 4 4 1127 0 rio.pg_toast.pg_toast_365051 1 0 0 0 contagem.pg_catalog.pg_depend 8 8 5661 0 rio.pg_catalog.pg_index 11 11 3113 0 rio.public.usuarios 10 5 273 0 rio.public.temp0000285210 4 0 0 0 template1.pg_catalog.pg_shdepend 8 8 6274 0 contagem.public.usuarios 16 0 975 0 contagem.pg_catalog.pg_statistic 5 5 8814 0 rio.public.temp0000285222 4 0 0 0 Total 541 273 469,208 5,934 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jul 13 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 6 0 06 0 0 07 15 23 08 49 119 09 45 151 10 68 147 11 44 146 12 9 44 13 44 113 14 65 152 15 74 172 16 34 117 17 82 144 18 0 1 19 0 0 20 0 0 21 6 5 22 0 0 23 0 0 - 14.56 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- ShareLock Main Lock Type
- 1 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 1 2m47s 2m47s 2m47s 2m47s call rs_giga_triagem (?);-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-13 11:08:05 Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-13 00:05:23 Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-13 20:05:17 Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
Queries that waited the most
Rank Wait time Query 1 2m47s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-07-13 11:08:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Queries
Queries by type
Key values
- 5,767 Total read queries
- 1,915 Total write queries
Queries by database
Key values
- rio Main database
- 5,209 Requests
- 7h23m35s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 8,798 Requests
User Request type Count Duration etiquetas Total 63 18s514ms select 63 18s514ms intelifix Total 8,798 14h13m34s copy to 827 1h42m3s ddl 1,500 55m10s others 755 1h15m5s select 5,716 10h21m14s lenon Total 126 1m56s select 126 1m56s Duration by user
Key values
- 14h13m34s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 63 18s514ms select 63 18s514ms intelifix Total 8,798 14h13m34s copy to 827 1h42m3s ddl 1,500 55m10s others 755 1h15m5s select 5,716 10h21m14s lenon Total 126 1m56s select 126 1m56s Queries by host
Key values
- [local] Main host
- 8,987 Requests
- 14h15m49s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 7,026 Requests
- 5h8m4s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 1 per second Cancelled query Peak
- 2026-07-13 18:23:26 Date
Number of cancelled queries (5 minutes period)
NO DATASET
Queries generating the most cancellation (N)
Rank Count Query 1 1 select "id", "cai_id", "lot_id", "lot_tipo", "lot_notafiscal", "ofi_nome", "cli_nome", "usu_nome", "mod_nome", "mod_mnemonico", "fabricante", "mac_address", "part_number", "barra1", "barra2", "barra3", "barra4", "corrigido1", "corrigido2", "corrigido3", "corrigido4", "extra1", "extra2", "extra3", "extra4", "nf_entrada", "valor", "motivo", "acessorio1", "acessorio2", "acessorio3", "acessorio4", "ssid", "ssid_5g", "senha", "senha_5g", "senha_admin", "user_admin", "modelo_legado", "legado1", "legado2", "legado3", "legado4", "sap", "sap1", "sap2", "material", "firmware", "serial", "caid", "macaddress", "end_principal", "ns", "temporario", "qr_code", "qr_code1", "qr_code2", "itens_caixa", "mac_4", "end_princ6", "end_princ6_5g" from "public"."rs_equipamento_etiquetas"; -
Top Queries
Histogram of query times
Key values
- 3,955 100-500ms duration
Slowest individual queries
Rank Duration Query 1 13m50s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-13 17:18:51 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 13m39s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-13 09:18:41 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 13m8s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-13 07:18:10 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 12m3s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-13 16:17:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 11m11s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-13 20:16:12 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 10m46s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-13 15:15:47 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 10m35s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-13 14:15:37 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 10m30s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-13 10:15:32 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 9m19s analyze verbose;[ Date: 2026-07-13 05:09:21 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 9m11s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-13 12:14:12 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 9m6s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-13 11:14:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 9m1s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_seriais_expedidos(6,DATE(''2026-06-01''),DATE(''2026-06-30'')) ;', '/var/www/html/tmp/temp_54.xlsx');[ Date: 2026-07-13 16:16:46 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
13 8m26s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026960, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-07-13 14:54:54 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
14 8m2s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026946, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-07-13 11:08:04 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
15 7m42s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026954, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-07-13 12:08:48 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
16 7m41s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026971, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-07-13 15:45:58 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
17 7m29s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-13 18:12:30 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 7m21s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026973, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-07-13 16:19:04 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
19 7m10s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026931, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-07-13 07:23:19 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
20 6m47s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026939, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-07-13 08:41:15 - 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 2h41m23s 48 1s313ms 13m50s 3m21s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 13 07 3 13m58s 4m39s 08 3 6m49s 2m16s 09 3 14m26s 4m48s 10 3 11m13s 3m44s 11 3 9m49s 3m16s 12 3 9m58s 3m19s 13 3 6m58s 2m19s 14 3 11m9s 3m43s 15 3 11m18s 3m46s 16 3 12m48s 4m16s 17 3 14m31s 4m50s 18 3 7m51s 2m37s 19 3 6m14s 2m4s 20 3 11m42s 3m54s 21 3 6m31s 2m10s 22 3 6m2s 2m [ User: intelifix - Total duration: 2h41m23s - Times executed: 48 ]
[ Application: psql - Total duration: 2h41m23s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-13 17:18:51 Duration: 13m50s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-13 09:18:41 Duration: 13m39s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-13 07:18:10 Duration: 13m8s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
2 1h41m14s 393 150ms 9m1s 15s456ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 13 07 25 12m17s 29s511ms 08 46 13m41s 17s850ms 09 27 6m6s 13s576ms 10 33 1m12s 2s203ms 11 47 8m53s 11s360ms 12 12 12m21s 1m1s 13 19 49s265ms 2s592ms 14 53 9m12s 10s415ms 15 47 15m5s 19s266ms 16 40 17m29s 26s239ms 17 44 4m4s 5s546ms [ User: intelifix - Total duration: 1h41m14s - Times executed: 393 ]
[ Application: [unknown] - Total duration: 1h41m14s - Times executed: 393 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_seriais_expedidos(6,DATE(''2026-06-01''),DATE(''2026-06-30'')) ;', '/var/www/html/tmp/temp_54.xlsx');
Date: 2026-07-13 16:16:46 Duration: 9m1s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026960, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-13 14:54:54 Duration: 8m26s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026946, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-13 11:08:04 Duration: 8m2s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
3 1h29m57s 48 261ms 5m27s 1m52s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 13 07 3 5m48s 1m56s 08 3 4m26s 1m28s 09 3 7m26s 2m28s 10 3 7m5s 2m21s 11 3 6m46s 2m15s 12 3 6m47s 2m15s 13 3 4m34s 1m31s 14 3 6m44s 2m14s 15 3 6m31s 2m10s 16 3 6m36s 2m12s 17 3 6m4s 2m1s 18 3 3m52s 1m17s 19 3 4m2s 1m20s 20 3 5m47s 1m55s 21 3 3m38s 1m12s 22 3 3m44s 1m14s [ User: intelifix - Total duration: 1h29m57s - Times executed: 48 ]
[ Application: psql - Total duration: 1h29m57s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-13 09:26:46 Duration: 5m27s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-13 14:22:48 Duration: 5m9s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-13 10:23:15 Duration: 5m8s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
4 33m51s 1,745 150ms 7s123ms 1s164ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 13 07 7 5s143ms 734ms 08 93 1m49s 1s172ms 09 172 2m55s 1s18ms 10 235 3m59s 1s20ms 11 184 3m4s 1s3ms 12 104 2m1s 1s164ms 13 143 2m16s 956ms 14 232 4m46s 1s235ms 15 207 4m51s 1s409ms 16 204 5m3s 1s487ms 17 164 2m57s 1s84ms [ User: intelifix - Total duration: 33m51s - Times executed: 1745 ]
[ Application: [unknown] - Total duration: 33m51s - Times executed: 1745 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (263251, 503, '7151638787H010901906,216562893755,216549396870,216753827192,216502508388,216410610925,216819198689,216909257490,216910554351,216790841636,216907935173,216562288588,216546048395,216799129616,184329975974,216505055057,216506405256,216907567280,216336657073,216817846975,216353333247,216410674062,216724122240,216834150004,216350694953,216865360727,216348586868,216413540717,216504622939,216515473650H010942423,216611360315,216814551436,216520126281,216336870002,216635478492,216833206061,216877517692,216866487794H010929170,216610035067,216410824458,216755961823', '',062,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-13 09:15:26 Duration: 7s123ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (265092, 304, '71716585850040302456,216791652534,216399994961,216836897274,216627199503,216816632626,216697675068,216519483839,216394285571,216753183639,216505995463,216607644048,216877591617,216360117578,216359637980,216799303247,216868461624,216410798394,216545862542,216697879914,216837382126,184271751729,216701428890,216738014549,216548338900,216832442542,216545267881,216503999511,216560922126,216837002134,216724401414,216561896373,216751257592,216835627891,216504942948,216876973240,216908167092H010987448,216634519599,216619146674,216408004755,216354517290', '',062,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-13 11:32:16 Duration: 6s911ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (265109, 304, 'CP2231LV0EE,4075C3296974$CP2238LV325,4075C3BFE2E8$CP2349LV172,400FC186A944$CP2347LV5PQ,400FC17DFE64$CP2111LV32S,08A7C04DD534$CP2432LV1JW,C4509CBEB45C$CP2346LV5HS,CCF3C897A354$CP2052LVEF2,484BD4AA7BCC$CP2127LV968,08A7C077D23C$CP2242LV41K,B85E71C7C34C$CP2240LVEBB,F8D2AC138908$CP2143LV503,1C9ECC8D523C$CP2146LV573,D4E2CB8DBB1C$CP2425LV1A3,C4509CAC90BC$CP2218LV1YK,00CB7ADD527C$CP2134LV3FW,ECA81F222D04$CP2051LV8N2,484BD4AA804C$CP2429LV6J4,C4509CBD4EFC$CP2526LV1UQ,B85E71115958$CP2046LV105,484BD48D5E7C$CP2226LV8VZ,80DAC2CF2424$CP2531LV3TS,3C82C08D6B10$CP2348LV4ZY,400FC1869984$CP2131LV96J,ECA81F19F8EC$CP2244LV0UG,B85E71D2B25C$CP2141LV45F,ECA81FF7ED8C$CP2240LV3M2,B85E71BFE3FC$CP2529LV36H,3C82C08D7CB8$CP2301LV46L,B85E71E77A5C$CP2528LV78L,F8D2AC4CE654$CP2242LVH0U,B85E71CAD2A8$CP2226LV6JJ,80DAC2CF7618$CP2218LV2W3,00CB7ADE8CDC$CP2302LV0LF,B85E71E66E14$CP2205LV8S1,3C82C06B8460$CP2134LV858,ECA81F234044$CP2347LVAN5,400FC1837914$CP2142LV5TV,ECA81FF79D04$CP2130LV31F,8C6A8DBE866C$CP2127LV1J9,08A7C075BC6C', '',0185,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-13 10:34:44 Duration: 6s457ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
5 16m20s 3 2m31s 9m19s 5m26s analyze verbose;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 13 05 3 16m20s 5m26s [ User: intelifix - Total duration: 16m20s - Times executed: 3 ]
[ Application: psql - Total duration: 16m20s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-07-13 05:09:21 Duration: 9m19s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
analyze verbose;
Date: 2026-07-13 05:13:50 Duration: 4m28s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
analyze verbose;
Date: 2026-07-13 05:16:22 Duration: 2m31s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
6 15m29s 1,186 150ms 6s923ms 783ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 13 08 110 1m37s 886ms 09 149 1m55s 776ms 10 190 2m25s 764ms 11 123 1m36s 780ms 12 1 1s155ms 1s155ms 13 142 1m55s 812ms 14 166 2m3s 746ms 15 187 2m18s 742ms 16 109 1m28s 807ms 17 9 7s153ms 794ms [ User: intelifix - Total duration: 15m29s - Times executed: 1186 ]
[ Application: [unknown] - Total duration: 15m29s - Times executed: 1186 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "103107", "modelo" : "287", "itens" : "229927648190,230004969811,229996529616,230012595168,229985409810,229997424058,229985327478,229930975979,229995361130,229937655576,229906090319,229960724550,229953430719,229991710426,229927792425,229969305466", "usuario" : "414", "caixa" : "1195710", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-13 13:57:43 Duration: 6s923ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "108194", "modelo" : "151", "itens" : "D86C5A56E338,C85D38FF6100,D86C5A5B16FA,C85D38816639,C85D38F7AD2F,C85D3869C2B2,D86C5A02D5A1,D86C5A67DCB0", "usuario" : "414", "caixa" : "1299288", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-13 15:20:48 Duration: 4s358ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "265249", "modelo" : "159", "itens" : "229762835574,229756297382,229682231827,229758172740,229680873445,229760367577,229681891536,229650673943,229682990218,229758090510,229682923443,229680024159,229650262534,229683873951,229682160103,216917591335,229650430912,229680548081,229681252629,229653372950,229682584162,229683360916,229653116583,229651631826,229652472828,229681135872,229654864857,229651449406,229681777887,229757043146,215861253640,229680923248,229757614144,229684069806,229679823354,229652087986,229759374866,229682325876,229653705866,229650967383,226881633252,229684301625,229650249299,229761621932,229654015167,229651011732,229683296868,229681686161", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-13 08:03:12 Duration: 3s586ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
7 15m28s 76 9s17ms 48s366ms 12s212ms create table temp0000285112 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 13 07 16 3m23s 12s744ms 08 12 2m18s 11s510ms 09 6 1m11s 11s869ms 10 6 1m20s 13s363ms 11 3 38s135ms 12s711ms 12 9 1m44s 11s607ms 14 7 1m26s 12s391ms 15 11 2m21s 12s826ms 16 6 1m4s 10s709ms [ User: intelifix - Total duration: 15m28s - Times executed: 76 ]
[ Application: [unknown] - Total duration: 15m28s - Times executed: 76 ]
-
CREATE TABLE temp0000285112 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-13 07:13:25 Duration: 48s366ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CREATE TABLE temp0000285112 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-13 15:37:19 Duration: 15s205ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CREATE TABLE temp0000285112 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-13 10:59:51 Duration: 14s724ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
8 14m25s 270 163ms 2m52s 3s204ms call rs_giga_triagem (?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 13 00 12 45s333ms 3s777ms 01 11 26s155ms 2s377ms 02 12 25s758ms 2s146ms 03 12 25s183ms 2s98ms 04 11 25s42ms 2s276ms 05 12 25s165ms 2s97ms 06 11 22s810ms 2s73ms 07 12 26s258ms 2s188ms 08 12 30s712ms 2s559ms 09 12 29s328ms 2s444ms 10 12 30s406ms 2s533ms 11 12 3m19s 16s637ms 12 12 27s310ms 2s275ms 13 12 28s368ms 2s364ms 14 12 29s728ms 2s477ms 15 12 34s935ms 2s911ms 16 12 42s538ms 3s544ms 17 12 31s167ms 2s597ms 18 12 27s715ms 2s309ms 19 12 30s329ms 2s527ms 20 10 47s419ms 4s741ms 21 12 27s22ms 2s251ms 22 11 26s997ms 2s454ms [ User: intelifix - Total duration: 14m25s - Times executed: 270 ]
[ Application: psql - Total duration: 14m25s - Times executed: 270 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-13 11:08:05 Duration: 2m52s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-13 00:05:23 Duration: 21s571ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-13 20:05:17 Duration: 13s646ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
9 9m11s 108 1s123ms 45s637ms 5s106ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 13 08 2 48s596ms 24s298ms 09 3 26s734ms 8s911ms 10 2 7s525ms 3s762ms 11 11 1m6s 6s80ms 12 7 18s558ms 2s651ms 13 2 4s415ms 2s207ms 14 17 1m 3s570ms 15 21 2m7s 6s65ms 16 20 1m55s 5s762ms 17 22 1m12s 3s287ms 18 1 3s133ms 3s133ms [ User: intelifix - Total duration: 9m11s - Times executed: 108 ]
[ Application: [unknown] - Total duration: 9m11s - Times executed: 108 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-13', 0395, '', '', 0, 6, '2026-07-01');
Date: 2026-07-13 08:30:51 Duration: 45s637ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-13', 099, '', '', 0, 6, '2026-07-01');
Date: 2026-07-13 16:32:30 Duration: 40s400ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-13', 0173, '', '', 0, 6, '2026-07-01');
Date: 2026-07-13 15:20:53 Duration: 38s346ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
10 5m53s 91 158ms 21s807ms 3s886ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 13 00 1 599ms 599ms 07 10 54s52ms 5s405ms 08 12 1m3s 5s300ms 09 12 50s128ms 4s177ms 10 10 1m6s 6s618ms 11 10 1m2s 6s289ms 12 7 9s512ms 1s358ms 13 6 7s563ms 1s260ms 14 6 9s163ms 1s527ms 15 6 15s442ms 2s573ms 16 6 10s302ms 1s717ms 17 4 4s86ms 1s21ms 20 1 174ms 174ms [ User: intelifix - Total duration: 5m53s - Times executed: 91 ]
[ Application: psql - Total duration: 5m53s - Times executed: 91 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-13 11:25:23 Duration: 21s807ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-13 10:05:16 Duration: 14s862ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-13 07:35:14 Duration: 12s905ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
11 5m39s 45 152ms 43s886ms 7s535ms select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 13 07 3 44s424ms 14s808ms 08 5 17s182ms 3s436ms 09 2 3s327ms 1s663ms 10 2 43s546ms 21s773ms 11 2 52s217ms 26s108ms 12 2 5s150ms 2s575ms 13 3 7s161ms 2s387ms 14 3 47s697ms 15s899ms 15 7 1m12s 10s308ms 16 2 11s314ms 5s657ms 17 14 34s912ms 2s493ms [ User: intelifix - Total duration: 5m39s - Times executed: 45 ]
[ Application: psql - Total duration: 5m39s - Times executed: 45 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (026960);
Date: 2026-07-13 14:46:30 Duration: 43s886ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (026931);
Date: 2026-07-13 07:16:17 Duration: 39s475ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (026946);
Date: 2026-07-13 10:59:53 Duration: 33s346ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
12 4m41s 2 2s342ms 4m39s 2m20s select * from rs_fast_excel (?, ?) / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (/ usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 13 08 1 4m39s 4m39s 10 1 2s342ms 2s342ms [ User: intelifix - Total duration: 4m41s - Times executed: 2 ]
[ Application: [unknown] - Total duration: 4m41s - Times executed: 2 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026937, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx') / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (/ usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-07-13 08:19:56 Duration: 4m39s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_exclui_seriais(''/var/www/html/uploads/EXCLUSÃO ATOP.xlsx'') ;', '/var/www/html/tmp/temp_83.xlsx') / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (/ usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-07-13 10:00:05 Duration: 2s342ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
13 3m46s 20 494ms 1m52s 11s302ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 13 08 6 40s639ms 6s773ms 13 2 1m56s 58s72ms 14 1 11s46ms 11s46ms 16 1 5s135ms 5s135ms 17 10 53s73ms 5s307ms [ User: intelifix - Total duration: 3m46s - Times executed: 20 ]
[ Application: psql - Total duration: 3m46s - Times executed: 20 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 416); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01527);
Date: 2026-07-13 13:13:54 Duration: 1m52s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT RS_SETGLOBAL ('USUARIO', 398); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (04375);
Date: 2026-07-13 08:03:28 Duration: 20s531ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT RS_SETGLOBAL ('USUARIO', 398); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (04384);
Date: 2026-07-13 17:02:28 Duration: 17s889ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
14 3m30s 173 736ms 1s997ms 1s217ms create table temp0000226614 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 13 09 29 33s429ms 1s152ms 10 41 47s916ms 1s168ms 11 15 17s722ms 1s181ms 13 23 29s642ms 1s288ms 14 33 44s390ms 1s345ms 15 27 31s663ms 1s172ms 16 5 5s811ms 1s162ms [ User: intelifix - Total duration: 3m30s - Times executed: 173 ]
[ Application: [unknown] - Total duration: 3m30s - Times executed: 173 ]
-
CREATE TABLE temp0000226614 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"2", "cliente" :"0", "desde" :"08-07-2026", "ate" :"13-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-13 14:41:14 Duration: 1s997ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CREATE TABLE temp0000226614 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"2", "cliente" :"1", "desde" :"08-07-2026", "ate" :"13-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-13 13:36:15 Duration: 1s991ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CREATE TABLE temp0000226614 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"2", "cliente" :"0", "desde" :"08-07-2026", "ate" :"13-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-13 10:04:12 Duration: 1s886ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
15 3m3s 4 4s502ms 1m29s 45s847ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 13 20 2 1m34s 47s162ms 23 2 1m29s 44s533ms [ User: intelifix - Total duration: 3m3s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m3s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-13 20:08:39 Duration: 1m29s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-13 23:37:42 Duration: 1m24s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-13 20:10:30 Duration: 4s867ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-13.log
16 2m58s 51 196ms 1m35s 3s495ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 13 07 6 6s540ms 1s90ms 08 4 2s434ms 608ms 09 3 11s798ms 3s932ms 10 4 24s139ms 6s34ms 11 7 2s631ms 375ms 12 3 1s791ms 597ms 13 1 8s393ms 8s393ms 14 3 6s324ms 2s108ms 15 11 1m39s 9s17ms 16 2 2s54ms 1s27ms 17 7 12s973ms 1s853ms [ User: intelifix - Total duration: 2m58s - Times executed: 51 ]
[ Application: psql - Total duration: 2m58s - Times executed: 51 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026969);
Date: 2026-07-13 15:25:57 Duration: 1m35s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT RS_SETGLOBAL ('USUARIO', 449); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026943);
Date: 2026-07-13 10:05:54 Duration: 12s852ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT RS_SETGLOBAL ('USUARIO', 449); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026942);
Date: 2026-07-13 09:53:36 Duration: 10s772ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
17 2m55s 155 150ms 15s964ms 1s133ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 13 07 19 13s612ms 716ms 08 26 21s738ms 836ms 09 11 21s480ms 1s952ms 10 2 18s153ms 9s76ms 11 30 33s600ms 1s120ms 13 2 4s849ms 2s424ms 14 22 19s901ms 904ms 15 13 16s19ms 1s232ms 16 18 18s386ms 1s21ms 17 12 7s978ms 664ms [ User: intelifix - Total duration: 2m55s - Times executed: 155 ]
[ Application: [unknown] - Total duration: 2m55s - Times executed: 155 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (045286) LIMIT 1;
Date: 2026-07-13 09:59:01 Duration: 15s964ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (045285) LIMIT 1;
Date: 2026-07-13 10:00:47 Duration: 11s359ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (045288) LIMIT 1;
Date: 2026-07-13 10:00:11 Duration: 6s794ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
18 2m53s 11 10s399ms 55s129ms 15s812ms create table temp0000285168 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 13 09 5 1m42s 20s588ms 10 6 1m10s 11s832ms [ User: intelifix - Total duration: 2m53s - Times executed: 11 ]
[ Application: [unknown] - Total duration: 2m53s - Times executed: 11 ]
-
CREATE TABLE temp0000285168 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-13 09:53:10 Duration: 55s129ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CREATE TABLE temp0000285168 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-13 10:06:15 Duration: 13s728ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CREATE TABLE temp0000285168 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-13 10:08:21 Duration: 13s383ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
19 2m33s 13 10s26ms 15s168ms 11s824ms create table temp0000285186 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 13 15 13 2m33s 11s824ms [ User: intelifix - Total duration: 2m33s - Times executed: 13 ]
[ Application: [unknown] - Total duration: 2m33s - Times executed: 13 ]
-
CREATE TABLE temp0000285186 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-13 15:02:07 Duration: 15s168ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CREATE TABLE temp0000285186 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-13 15:02:31 Duration: 13s307ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CREATE TABLE temp0000285186 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-13 15:22:06 Duration: 12s834ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
20 2m32s 10 10s632ms 45s500ms 15s240ms create table temp0000285164 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 13 11 10 2m32s 15s240ms [ User: intelifix - Total duration: 2m32s - Times executed: 10 ]
[ Application: [unknown] - Total duration: 2m32s - Times executed: 10 ]
-
CREATE TABLE temp0000285164 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-13 11:39:38 Duration: 45s500ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CREATE TABLE temp0000285164 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-13 11:42:17 Duration: 13s355ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CREATE TABLE temp0000285164 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-13 11:42:38 Duration: 12s659ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1,745 33m51s 150ms 7s123ms 1s164ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 13 07 7 5s143ms 734ms 08 93 1m49s 1s172ms 09 172 2m55s 1s18ms 10 235 3m59s 1s20ms 11 184 3m4s 1s3ms 12 104 2m1s 1s164ms 13 143 2m16s 956ms 14 232 4m46s 1s235ms 15 207 4m51s 1s409ms 16 204 5m3s 1s487ms 17 164 2m57s 1s84ms [ User: intelifix - Total duration: 33m51s - Times executed: 1745 ]
[ Application: [unknown] - Total duration: 33m51s - Times executed: 1745 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (263251, 503, '7151638787H010901906,216562893755,216549396870,216753827192,216502508388,216410610925,216819198689,216909257490,216910554351,216790841636,216907935173,216562288588,216546048395,216799129616,184329975974,216505055057,216506405256,216907567280,216336657073,216817846975,216353333247,216410674062,216724122240,216834150004,216350694953,216865360727,216348586868,216413540717,216504622939,216515473650H010942423,216611360315,216814551436,216520126281,216336870002,216635478492,216833206061,216877517692,216866487794H010929170,216610035067,216410824458,216755961823', '',062,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-13 09:15:26 Duration: 7s123ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (265092, 304, '71716585850040302456,216791652534,216399994961,216836897274,216627199503,216816632626,216697675068,216519483839,216394285571,216753183639,216505995463,216607644048,216877591617,216360117578,216359637980,216799303247,216868461624,216410798394,216545862542,216697879914,216837382126,184271751729,216701428890,216738014549,216548338900,216832442542,216545267881,216503999511,216560922126,216837002134,216724401414,216561896373,216751257592,216835627891,216504942948,216876973240,216908167092H010987448,216634519599,216619146674,216408004755,216354517290', '',062,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-13 11:32:16 Duration: 6s911ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (265109, 304, 'CP2231LV0EE,4075C3296974$CP2238LV325,4075C3BFE2E8$CP2349LV172,400FC186A944$CP2347LV5PQ,400FC17DFE64$CP2111LV32S,08A7C04DD534$CP2432LV1JW,C4509CBEB45C$CP2346LV5HS,CCF3C897A354$CP2052LVEF2,484BD4AA7BCC$CP2127LV968,08A7C077D23C$CP2242LV41K,B85E71C7C34C$CP2240LVEBB,F8D2AC138908$CP2143LV503,1C9ECC8D523C$CP2146LV573,D4E2CB8DBB1C$CP2425LV1A3,C4509CAC90BC$CP2218LV1YK,00CB7ADD527C$CP2134LV3FW,ECA81F222D04$CP2051LV8N2,484BD4AA804C$CP2429LV6J4,C4509CBD4EFC$CP2526LV1UQ,B85E71115958$CP2046LV105,484BD48D5E7C$CP2226LV8VZ,80DAC2CF2424$CP2531LV3TS,3C82C08D6B10$CP2348LV4ZY,400FC1869984$CP2131LV96J,ECA81F19F8EC$CP2244LV0UG,B85E71D2B25C$CP2141LV45F,ECA81FF7ED8C$CP2240LV3M2,B85E71BFE3FC$CP2529LV36H,3C82C08D7CB8$CP2301LV46L,B85E71E77A5C$CP2528LV78L,F8D2AC4CE654$CP2242LVH0U,B85E71CAD2A8$CP2226LV6JJ,80DAC2CF7618$CP2218LV2W3,00CB7ADE8CDC$CP2302LV0LF,B85E71E66E14$CP2205LV8S1,3C82C06B8460$CP2134LV858,ECA81F234044$CP2347LVAN5,400FC1837914$CP2142LV5TV,ECA81FF79D04$CP2130LV31F,8C6A8DBE866C$CP2127LV1J9,08A7C075BC6C', '',0185,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-13 10:34:44 Duration: 6s457ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
2 1,186 15m29s 150ms 6s923ms 783ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 13 08 110 1m37s 886ms 09 149 1m55s 776ms 10 190 2m25s 764ms 11 123 1m36s 780ms 12 1 1s155ms 1s155ms 13 142 1m55s 812ms 14 166 2m3s 746ms 15 187 2m18s 742ms 16 109 1m28s 807ms 17 9 7s153ms 794ms [ User: intelifix - Total duration: 15m29s - Times executed: 1186 ]
[ Application: [unknown] - Total duration: 15m29s - Times executed: 1186 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "103107", "modelo" : "287", "itens" : "229927648190,230004969811,229996529616,230012595168,229985409810,229997424058,229985327478,229930975979,229995361130,229937655576,229906090319,229960724550,229953430719,229991710426,229927792425,229969305466", "usuario" : "414", "caixa" : "1195710", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-13 13:57:43 Duration: 6s923ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "108194", "modelo" : "151", "itens" : "D86C5A56E338,C85D38FF6100,D86C5A5B16FA,C85D38816639,C85D38F7AD2F,C85D3869C2B2,D86C5A02D5A1,D86C5A67DCB0", "usuario" : "414", "caixa" : "1299288", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-13 15:20:48 Duration: 4s358ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "265249", "modelo" : "159", "itens" : "229762835574,229756297382,229682231827,229758172740,229680873445,229760367577,229681891536,229650673943,229682990218,229758090510,229682923443,229680024159,229650262534,229683873951,229682160103,216917591335,229650430912,229680548081,229681252629,229653372950,229682584162,229683360916,229653116583,229651631826,229652472828,229681135872,229654864857,229651449406,229681777887,229757043146,215861253640,229680923248,229757614144,229684069806,229679823354,229652087986,229759374866,229682325876,229653705866,229650967383,226881633252,229684301625,229650249299,229761621932,229654015167,229651011732,229683296868,229681686161", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-13 08:03:12 Duration: 3s586ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
3 393 1h41m14s 150ms 9m1s 15s456ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 13 07 25 12m17s 29s511ms 08 46 13m41s 17s850ms 09 27 6m6s 13s576ms 10 33 1m12s 2s203ms 11 47 8m53s 11s360ms 12 12 12m21s 1m1s 13 19 49s265ms 2s592ms 14 53 9m12s 10s415ms 15 47 15m5s 19s266ms 16 40 17m29s 26s239ms 17 44 4m4s 5s546ms [ User: intelifix - Total duration: 1h41m14s - Times executed: 393 ]
[ Application: [unknown] - Total duration: 1h41m14s - Times executed: 393 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_seriais_expedidos(6,DATE(''2026-06-01''),DATE(''2026-06-30'')) ;', '/var/www/html/tmp/temp_54.xlsx');
Date: 2026-07-13 16:16:46 Duration: 9m1s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026960, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-13 14:54:54 Duration: 8m26s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026946, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-13 11:08:04 Duration: 8m2s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
4 270 14m25s 163ms 2m52s 3s204ms call rs_giga_triagem (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 13 00 12 45s333ms 3s777ms 01 11 26s155ms 2s377ms 02 12 25s758ms 2s146ms 03 12 25s183ms 2s98ms 04 11 25s42ms 2s276ms 05 12 25s165ms 2s97ms 06 11 22s810ms 2s73ms 07 12 26s258ms 2s188ms 08 12 30s712ms 2s559ms 09 12 29s328ms 2s444ms 10 12 30s406ms 2s533ms 11 12 3m19s 16s637ms 12 12 27s310ms 2s275ms 13 12 28s368ms 2s364ms 14 12 29s728ms 2s477ms 15 12 34s935ms 2s911ms 16 12 42s538ms 3s544ms 17 12 31s167ms 2s597ms 18 12 27s715ms 2s309ms 19 12 30s329ms 2s527ms 20 10 47s419ms 4s741ms 21 12 27s22ms 2s251ms 22 11 26s997ms 2s454ms [ User: intelifix - Total duration: 14m25s - Times executed: 270 ]
[ Application: psql - Total duration: 14m25s - Times executed: 270 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-13 11:08:05 Duration: 2m52s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-13 00:05:23 Duration: 21s571ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-13 20:05:17 Duration: 13s646ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
5 224 37s87ms 150ms 247ms 165ms select * from rs_modelos_lista (null, null) where mod_id = ?;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 13 07 6 983ms 163ms 08 16 2s687ms 167ms 09 22 3s624ms 164ms 10 26 4s344ms 167ms 11 20 3s342ms 167ms 12 7 1s157ms 165ms 13 20 3s289ms 164ms 14 43 7s141ms 166ms 15 36 6s57ms 168ms 16 26 4s149ms 159ms 17 2 309ms 154ms [ User: intelifix - Total duration: 37s87ms - Times executed: 224 ]
[ Application: [unknown] - Total duration: 37s87ms - Times executed: 224 ]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 0185;
Date: 2026-07-13 08:35:01 Duration: 247ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 00;
Date: 2026-07-13 14:03:19 Duration: 219ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 00;
Date: 2026-07-13 10:02:16 Duration: 214ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
6 211 45s891ms 150ms 719ms 217ms select * from rs_lote_manutencao (?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 13 07 5 1s759ms 351ms 08 3 928ms 309ms 09 45 9s354ms 207ms 10 48 9s482ms 197ms 11 37 7s515ms 203ms 13 26 5s357ms 206ms 14 20 3s892ms 194ms 15 22 5s971ms 271ms 16 3 967ms 322ms 17 2 660ms 330ms [ User: intelifix - Total duration: 45s891ms - Times executed: 211 ]
[ Application: [unknown] - Total duration: 45s891ms - Times executed: 211 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"2", "cliente" :"1", "modelo" :"318", "usuario" :"418", "tipo" :"N", "itens" :"001", "nota-fiscal" :"10866", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}');
Date: 2026-07-13 09:01:28 Duration: 719ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"6", "cliente" :"5", "modelo" :"303", "usuario" :"507", "tipo" :"N", "itens" :"001", "nota-fiscal" :"1563", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}');
Date: 2026-07-13 07:27:18 Duration: 681ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"2", "cliente" :"1", "modelo" :"172", "usuario" :"406", "tipo" :"N", "itens" :"006", "nota-fiscal" :"10897", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}');
Date: 2026-07-13 16:18:04 Duration: 649ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
7 207 1m3s 150ms 976ms 307ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 13 07 22 7s916ms 359ms 08 23 7s984ms 347ms 09 24 6s865ms 286ms 10 18 5s643ms 313ms 11 21 6s748ms 321ms 12 26 8s65ms 310ms 13 2 529ms 264ms 14 26 7s722ms 297ms 15 29 8s165ms 281ms 16 15 3s695ms 246ms 17 1 259ms 259ms [ User: intelifix - Total duration: 1m3s - Times executed: 207 ]
[ Application: [unknown] - Total duration: 1m3s - Times executed: 207 ]
-
SELECT * FROM RS_TRIAGEM (405, 5, '113', 3, '216629851738,216543075872,216838939315,216876760515,216354991333,216556296567,216633729007,216835126170', NULL, NULL, 062, 00);
Date: 2026-07-13 07:10:34 Duration: 976ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_TRIAGEM (407, 5, '113', 3, '229936392535,229947830105,229949381031,229959913854,229993027792,229953462540,229926357088,229958287993,229991753841,229931617691,229947209202,229961561535,229996271533', NULL, NULL, 0287, 00);
Date: 2026-07-13 11:38:43 Duration: 835ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_TRIAGEM (404, 5, '113', 3, '229721711112,229657246481,216947676178,216917677380,216903674555,216903683849,229722232532,229724581628,216856437374,229656658488,216856434647', NULL, NULL, 0131, 00);
Date: 2026-07-13 08:49:48 Duration: 799ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
8 179 35s235ms 150ms 928ms 196ms select * from rs_equipamento_consulta (?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 13 06 2 810ms 405ms 07 10 2s71ms 207ms 08 23 4s528ms 196ms 09 13 2s362ms 181ms 10 13 2s234ms 171ms 11 33 6s217ms 188ms 12 5 810ms 162ms 13 1 179ms 179ms 14 26 4s610ms 177ms 15 24 4s650ms 193ms 16 10 2s8ms 200ms 17 12 2s93ms 174ms 21 3 779ms 259ms 22 1 185ms 185ms 23 3 1s692ms 564ms [ User: intelifix - Total duration: 35s235ms - Times executed: 179 ]
[ Application: [unknown] - Total duration: 35s235ms - Times executed: 179 ]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('229853634256');
Date: 2026-07-13 23:37:48 Duration: 928ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('229913538687');
Date: 2026-07-13 23:41:18 Duration: 574ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('C85D38656304');
Date: 2026-07-13 06:54:02 Duration: 513ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
9 173 3m30s 736ms 1s997ms 1s217ms create table temp0000226614 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 13 09 29 33s429ms 1s152ms 10 41 47s916ms 1s168ms 11 15 17s722ms 1s181ms 13 23 29s642ms 1s288ms 14 33 44s390ms 1s345ms 15 27 31s663ms 1s172ms 16 5 5s811ms 1s162ms [ User: intelifix - Total duration: 3m30s - Times executed: 173 ]
[ Application: [unknown] - Total duration: 3m30s - Times executed: 173 ]
-
CREATE TABLE temp0000226614 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"2", "cliente" :"0", "desde" :"08-07-2026", "ate" :"13-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-13 14:41:14 Duration: 1s997ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CREATE TABLE temp0000226614 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"2", "cliente" :"1", "desde" :"08-07-2026", "ate" :"13-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-13 13:36:15 Duration: 1s991ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CREATE TABLE temp0000226614 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"2", "cliente" :"0", "desde" :"08-07-2026", "ate" :"13-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-13 10:04:12 Duration: 1s886ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
10 168 44s507ms 150ms 3s542ms 264ms select * from rs_produtividade_horas_html (?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 13 07 2 3s894ms 1s947ms 08 5 988ms 197ms 09 1 160ms 160ms 10 3 743ms 247ms 11 12 2s142ms 178ms 12 4 738ms 184ms 13 2 331ms 165ms 14 25 5s712ms 228ms 15 26 6s894ms 265ms 16 46 10s568ms 229ms 17 42 12s332ms 293ms [ User: intelifix - Total duration: 44s507ms - Times executed: 168 ]
[ Application: [unknown] - Total duration: 44s507ms - Times executed: 168 ]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "362", "data-de" : "2026-07-10", "data-ate" : "2026-07-10", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 414 }');
Date: 2026-07-13 07:09:33 Duration: 3s542ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "431", "data-de" : "2026-07-13", "data-ate" : "2026-07-13", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 504 }');
Date: 2026-07-13 15:41:50 Duration: 1s208ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "382", "data-de" : "2026-07-13", "data-ate" : "2026-07-13", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 433 }');
Date: 2026-07-13 17:08:12 Duration: 1s162ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
11 155 2m55s 150ms 15s964ms 1s133ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 13 07 19 13s612ms 716ms 08 26 21s738ms 836ms 09 11 21s480ms 1s952ms 10 2 18s153ms 9s76ms 11 30 33s600ms 1s120ms 13 2 4s849ms 2s424ms 14 22 19s901ms 904ms 15 13 16s19ms 1s232ms 16 18 18s386ms 1s21ms 17 12 7s978ms 664ms [ User: intelifix - Total duration: 2m55s - Times executed: 155 ]
[ Application: [unknown] - Total duration: 2m55s - Times executed: 155 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (045286) LIMIT 1;
Date: 2026-07-13 09:59:01 Duration: 15s964ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (045285) LIMIT 1;
Date: 2026-07-13 10:00:47 Duration: 11s359ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (045288) LIMIT 1;
Date: 2026-07-13 10:00:11 Duration: 6s794ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
12 114 54s177ms 268ms 846ms 475ms select pro_id, pgp_sym_decrypt(nome, ?)::varchar, pgp_sym_decrypt(descricao, ?)::varchar, pgp_sym_decrypt(classe, ?)::varchar, pgp_sym_decrypt(php, ?)::varchar, pgp_sym_decrypt(extras, ?)::varchar from progs order by pro_id;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 13 06 1 466ms 466ms 07 7 3s197ms 456ms 08 11 4s937ms 448ms 09 13 6s783ms 521ms 10 9 4s190ms 465ms 11 8 3s997ms 499ms 12 6 2s799ms 466ms 13 14 6s902ms 493ms 14 10 4s694ms 469ms 15 9 4s616ms 512ms 16 12 5s660ms 471ms 17 11 4s698ms 427ms 18 1 357ms 357ms 20 1 399ms 399ms 21 1 476ms 476ms [ User: lenon - Total duration: 54s177ms - Times executed: 114 ]
[ Application: [unknown] - Total duration: 54s177ms - Times executed: 114 ]
-
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-13 15:13:59 Duration: 846ms Database: brasilia User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
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-13 13:55:19 Duration: 835ms Database: contagem User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
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-13 15:15:20 Duration: 766ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-13.log
13 108 9m11s 1s123ms 45s637ms 5s106ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 13 08 2 48s596ms 24s298ms 09 3 26s734ms 8s911ms 10 2 7s525ms 3s762ms 11 11 1m6s 6s80ms 12 7 18s558ms 2s651ms 13 2 4s415ms 2s207ms 14 17 1m 3s570ms 15 21 2m7s 6s65ms 16 20 1m55s 5s762ms 17 22 1m12s 3s287ms 18 1 3s133ms 3s133ms [ User: intelifix - Total duration: 9m11s - Times executed: 108 ]
[ Application: [unknown] - Total duration: 9m11s - Times executed: 108 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-13', 0395, '', '', 0, 6, '2026-07-01');
Date: 2026-07-13 08:30:51 Duration: 45s637ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-13', 099, '', '', 0, 6, '2026-07-01');
Date: 2026-07-13 16:32:30 Duration: 40s400ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-13', 0173, '', '', 0, 6, '2026-07-01');
Date: 2026-07-13 15:20:53 Duration: 38s346ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
14 105 1m2s 352ms 1s96ms 593ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 13 07 5 2s533ms 506ms 08 9 5s264ms 584ms 09 13 8s204ms 631ms 10 9 5s355ms 595ms 11 8 5s97ms 637ms 12 5 2s853ms 570ms 13 14 8s406ms 600ms 14 9 5s298ms 588ms 15 9 5s703ms 633ms 16 12 7s274ms 606ms 17 11 5s840ms 530ms 18 1 512ms 512ms [ User: intelifix - Total duration: 1m2s - Times executed: 105 ]
[ Application: [unknown] - Total duration: 1m2s - Times executed: 105 ]
-
select * from rs_menu_grants (428, 21, 1);
Date: 2026-07-13 16:17:43 Duration: 1s96ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
select * from rs_menu_grants (397, 18, 1);
Date: 2026-07-13 15:13:59 Duration: 1s31ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
select * from rs_menu_grants (401, 53, 1);
Date: 2026-07-13 12:35:06 Duration: 947ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
15 100 42s684ms 152ms 857ms 426ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 13 07 3 1s217ms 405ms 08 10 4s30ms 403ms 09 12 4s798ms 399ms 10 11 4s438ms 403ms 11 4 1s581ms 395ms 12 7 2s964ms 423ms 13 6 2s112ms 352ms 14 7 3s93ms 441ms 15 14 6s320ms 451ms 16 8 4s97ms 512ms 17 18 8s29ms 446ms [ User: intelifix - Total duration: 42s684ms - Times executed: 100 ]
[ Application: [unknown] - Total duration: 42s684ms - Times executed: 100 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-07-13 16:34:22 Duration: 857ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-07-13 15:36:29 Duration: 708ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-07-13 14:40:10 Duration: 707ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
16 91 5m53s 158ms 21s807ms 3s886ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 13 00 1 599ms 599ms 07 10 54s52ms 5s405ms 08 12 1m3s 5s300ms 09 12 50s128ms 4s177ms 10 10 1m6s 6s618ms 11 10 1m2s 6s289ms 12 7 9s512ms 1s358ms 13 6 7s563ms 1s260ms 14 6 9s163ms 1s527ms 15 6 15s442ms 2s573ms 16 6 10s302ms 1s717ms 17 4 4s86ms 1s21ms 20 1 174ms 174ms [ User: intelifix - Total duration: 5m53s - Times executed: 91 ]
[ Application: psql - Total duration: 5m53s - Times executed: 91 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-13 11:25:23 Duration: 21s807ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-13 10:05:16 Duration: 14s862ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-13 07:35:14 Duration: 12s905ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
17 85 41s644ms 152ms 2s894ms 489ms select * from rs_lote_saida_manutencao (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 13 07 1 231ms 231ms 08 7 1s584ms 226ms 09 9 2s128ms 236ms 10 9 4s659ms 517ms 11 21 18s197ms 866ms 13 4 1s294ms 323ms 14 10 4s83ms 408ms 15 9 2s993ms 332ms 16 7 4s270ms 610ms 17 8 2s199ms 274ms [ User: intelifix - Total duration: 41s644ms - Times executed: 85 ]
[ Application: [unknown] - Total duration: 41s644ms - Times executed: 85 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO ('{ "id" : "42960", "oficina" : "2", "cliente" : "1", "usuario" : "406", "nf" : "000081475", "data-saida" : "2026-07-06", "sucata" : "D", "garantia" : "N", "fatura" : "", "data-fatura" : "", "data-inspecao" : "", "fechado" : "N", "valorado" : "", "motivo" : "0", "obs" : "PRIORIDADE ECO -LOTE 20", "def-extras" : "N", "acessorios" : "[]", "nf-vivo" : "0" }');
Date: 2026-07-13 11:07:36 Duration: 2s894ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO ('{ "id" : "44100", "oficina" : "2", "cliente" : "1", "usuario" : "406", "nf" : "000081663", "data-saida" : "2026-07-09", "sucata" : "D", "garantia" : "N", "fatura" : "", "data-fatura" : "", "data-inspecao" : "", "fechado" : "N", "valorado" : "", "motivo" : "0", "obs" : "PRIORIDADE RIO -LOTE 22", "def-extras" : "N", "acessorios" : "[]", "nf-vivo" : "0" }');
Date: 2026-07-13 11:04:18 Duration: 2s286ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO ('{ "id" : "42959", "oficina" : "2", "cliente" : "1", "usuario" : "406", "nf" : "000081471", "data-saida" : "2026-07-06", "sucata" : "D", "garantia" : "N", "fatura" : "", "data-fatura" : "", "data-inspecao" : "", "fechado" : "N", "valorado" : "", "motivo" : "0", "obs" : "PRIORIDADE RIO -LOTE 20", "def-extras" : "N", "acessorios" : "[]", "nf-vivo" : "0" }');
Date: 2026-07-13 11:07:47 Duration: 2s130ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
18 76 15m28s 9s17ms 48s366ms 12s212ms create table temp0000285112 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 13 07 16 3m23s 12s744ms 08 12 2m18s 11s510ms 09 6 1m11s 11s869ms 10 6 1m20s 13s363ms 11 3 38s135ms 12s711ms 12 9 1m44s 11s607ms 14 7 1m26s 12s391ms 15 11 2m21s 12s826ms 16 6 1m4s 10s709ms [ User: intelifix - Total duration: 15m28s - Times executed: 76 ]
[ Application: [unknown] - Total duration: 15m28s - Times executed: 76 ]
-
CREATE TABLE temp0000285112 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-13 07:13:25 Duration: 48s366ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CREATE TABLE temp0000285112 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-13 15:37:19 Duration: 15s205ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CREATE TABLE temp0000285112 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-13 10:59:51 Duration: 14s724ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
19 76 23s776ms 150ms 1s80ms 312ms select * from rs_baixa_executa (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 13 08 6 1s662ms 277ms 09 13 3s845ms 295ms 10 3 1s363ms 454ms 11 6 1s779ms 296ms 13 7 2s221ms 317ms 14 9 2s715ms 301ms 15 17 5s522ms 324ms 16 15 4s665ms 311ms [ User: intelifix - Total duration: 23s776ms - Times executed: 76 ]
[ Application: [unknown] - Total duration: 23s776ms - Times executed: 76 ]
-
SELECT * FROM RS_BAIXA_EXECUTA (310, 5, 7, 6, '840112299F21,8401122990C6,9877E7BA1FB4,9877E77CA09E,743AEF965E13,9877E707D0BC,9877E74B79E8,9877E70C6677', '77;1', 'DEFAULT', 09, 0153, '','', '', 00);
Date: 2026-07-13 15:57:15 Duration: 1s80ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_BAIXA_EXECUTA (310, 5, 7, 6, '8401128391CC,840112DBB7EF,9877E7B8EDF2,84011284BF58,743AEFABA472,840112C255A7,9877E7B84EB9,743AEF9B8B94,9877E74E3BEC,743AEF5C3973', '77;1', 'DEFAULT', 09, 0153, '','', '', 00);
Date: 2026-07-13 16:13:18 Duration: 908ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_BAIXA_EXECUTA (310, 5, 7, 6, '84011281CC4D,840112804366,8401120540C3,9877E7BD1749,1834AF28CB38,1834AF28655D,9877E7BA22D9,84011203F347,743AEF9A9D39', '77;1', 'DEFAULT', 09, 0153, '','', '', 00);
Date: 2026-07-13 16:27:35 Duration: 804ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
20 75 18s476ms 155ms 824ms 246ms create table temp0000235980 as select * from rs_lotes_saida_lista (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 13 13 4 1s162ms 290ms 14 13 2s733ms 210ms 15 14 3s521ms 251ms 16 14 3s829ms 273ms 17 30 7s228ms 240ms [ User: intelifix - Total duration: 18s476ms - Times executed: 75 ]
[ Application: [unknown] - Total duration: 18s476ms - Times executed: 75 ]
-
CREATE TABLE temp0000235980 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "7", "cliente" : "0", "nf" : "", "data-de" : "13-07-2026", "data-ate" : "13-07-2026", "grupo" : "0", "status" : "-1", "tipo" : "N", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-07-13 16:17:44 Duration: 824ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CREATE TABLE temp0000235980 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "7", "cliente" : "0", "nf" : "", "data-de" : "08-07-2026", "data-ate" : "13-07-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-07-13 13:10:32 Duration: 500ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CREATE TABLE temp0000235980 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "7", "cliente" : "0", "nf" : "", "data-de" : "13-07-2026", "data-ate" : "13-07-2026", "grupo" : "0", "status" : "-1", "tipo" : "N", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-07-13 16:19:39 Duration: 345ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 2m31s 9m19s 5m26s 3 16m20s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 13 05 3 16m20s 5m26s [ User: intelifix - Total duration: 16m20s - Times executed: 3 ]
[ Application: psql - Total duration: 16m20s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-07-13 05:09:21 Duration: 9m19s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
analyze verbose;
Date: 2026-07-13 05:13:50 Duration: 4m28s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
analyze verbose;
Date: 2026-07-13 05:16:22 Duration: 2m31s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
2 1s313ms 13m50s 3m21s 48 2h41m23s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 13 07 3 13m58s 4m39s 08 3 6m49s 2m16s 09 3 14m26s 4m48s 10 3 11m13s 3m44s 11 3 9m49s 3m16s 12 3 9m58s 3m19s 13 3 6m58s 2m19s 14 3 11m9s 3m43s 15 3 11m18s 3m46s 16 3 12m48s 4m16s 17 3 14m31s 4m50s 18 3 7m51s 2m37s 19 3 6m14s 2m4s 20 3 11m42s 3m54s 21 3 6m31s 2m10s 22 3 6m2s 2m [ User: intelifix - Total duration: 2h41m23s - Times executed: 48 ]
[ Application: psql - Total duration: 2h41m23s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-13 17:18:51 Duration: 13m50s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-13 09:18:41 Duration: 13m39s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-13 07:18:10 Duration: 13m8s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
3 2s342ms 4m39s 2m20s 2 4m41s select * from rs_fast_excel (?, ?) / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (/ usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 13 08 1 4m39s 4m39s 10 1 2s342ms 2s342ms [ User: intelifix - Total duration: 4m41s - Times executed: 2 ]
[ Application: [unknown] - Total duration: 4m41s - Times executed: 2 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026937, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx') / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (/ usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-07-13 08:19:56 Duration: 4m39s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_exclui_seriais(''/var/www/html/uploads/EXCLUSÃO ATOP.xlsx'') ;', '/var/www/html/tmp/temp_83.xlsx') / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (/ usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-07-13 10:00:05 Duration: 2s342ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
4 261ms 5m27s 1m52s 48 1h29m57s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 13 07 3 5m48s 1m56s 08 3 4m26s 1m28s 09 3 7m26s 2m28s 10 3 7m5s 2m21s 11 3 6m46s 2m15s 12 3 6m47s 2m15s 13 3 4m34s 1m31s 14 3 6m44s 2m14s 15 3 6m31s 2m10s 16 3 6m36s 2m12s 17 3 6m4s 2m1s 18 3 3m52s 1m17s 19 3 4m2s 1m20s 20 3 5m47s 1m55s 21 3 3m38s 1m12s 22 3 3m44s 1m14s [ User: intelifix - Total duration: 1h29m57s - Times executed: 48 ]
[ Application: psql - Total duration: 1h29m57s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-13 09:26:46 Duration: 5m27s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-13 14:22:48 Duration: 5m9s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-13 10:23:15 Duration: 5m8s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
5 4s502ms 1m29s 45s847ms 4 3m3s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 13 20 2 1m34s 47s162ms 23 2 1m29s 44s533ms [ User: intelifix - Total duration: 3m3s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m3s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-13 20:08:39 Duration: 1m29s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-13 23:37:42 Duration: 1m24s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-13 20:10:30 Duration: 4s867ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-13.log
6 10s399ms 55s129ms 15s812ms 11 2m53s create table temp0000285168 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 13 09 5 1m42s 20s588ms 10 6 1m10s 11s832ms [ User: intelifix - Total duration: 2m53s - Times executed: 11 ]
[ Application: [unknown] - Total duration: 2m53s - Times executed: 11 ]
-
CREATE TABLE temp0000285168 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-13 09:53:10 Duration: 55s129ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CREATE TABLE temp0000285168 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-13 10:06:15 Duration: 13s728ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CREATE TABLE temp0000285168 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-13 10:08:21 Duration: 13s383ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
7 150ms 9m1s 15s456ms 393 1h41m14s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 13 07 25 12m17s 29s511ms 08 46 13m41s 17s850ms 09 27 6m6s 13s576ms 10 33 1m12s 2s203ms 11 47 8m53s 11s360ms 12 12 12m21s 1m1s 13 19 49s265ms 2s592ms 14 53 9m12s 10s415ms 15 47 15m5s 19s266ms 16 40 17m29s 26s239ms 17 44 4m4s 5s546ms [ User: intelifix - Total duration: 1h41m14s - Times executed: 393 ]
[ Application: [unknown] - Total duration: 1h41m14s - Times executed: 393 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_seriais_expedidos(6,DATE(''2026-06-01''),DATE(''2026-06-30'')) ;', '/var/www/html/tmp/temp_54.xlsx');
Date: 2026-07-13 16:16:46 Duration: 9m1s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026960, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-13 14:54:54 Duration: 8m26s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026946, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-13 11:08:04 Duration: 8m2s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
8 10s632ms 45s500ms 15s240ms 10 2m32s create table temp0000285164 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 13 11 10 2m32s 15s240ms [ User: intelifix - Total duration: 2m32s - Times executed: 10 ]
[ Application: [unknown] - Total duration: 2m32s - Times executed: 10 ]
-
CREATE TABLE temp0000285164 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-13 11:39:38 Duration: 45s500ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CREATE TABLE temp0000285164 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-13 11:42:17 Duration: 13s355ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CREATE TABLE temp0000285164 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-13 11:42:38 Duration: 12s659ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
9 9s17ms 48s366ms 12s212ms 76 15m28s create table temp0000285112 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 13 07 16 3m23s 12s744ms 08 12 2m18s 11s510ms 09 6 1m11s 11s869ms 10 6 1m20s 13s363ms 11 3 38s135ms 12s711ms 12 9 1m44s 11s607ms 14 7 1m26s 12s391ms 15 11 2m21s 12s826ms 16 6 1m4s 10s709ms [ User: intelifix - Total duration: 15m28s - Times executed: 76 ]
[ Application: [unknown] - Total duration: 15m28s - Times executed: 76 ]
-
CREATE TABLE temp0000285112 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-13 07:13:25 Duration: 48s366ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CREATE TABLE temp0000285112 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-13 15:37:19 Duration: 15s205ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CREATE TABLE temp0000285112 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-13 10:59:51 Duration: 14s724ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
10 10s26ms 15s168ms 11s824ms 13 2m33s create table temp0000285186 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 13 15 13 2m33s 11s824ms [ User: intelifix - Total duration: 2m33s - Times executed: 13 ]
[ Application: [unknown] - Total duration: 2m33s - Times executed: 13 ]
-
CREATE TABLE temp0000285186 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-13 15:02:07 Duration: 15s168ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CREATE TABLE temp0000285186 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-13 15:02:31 Duration: 13s307ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CREATE TABLE temp0000285186 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-13 15:22:06 Duration: 12s834ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
11 494ms 1m52s 11s302ms 20 3m46s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel (?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 13 08 6 40s639ms 6s773ms 13 2 1m56s 58s72ms 14 1 11s46ms 11s46ms 16 1 5s135ms 5s135ms 17 10 53s73ms 5s307ms [ User: intelifix - Total duration: 3m46s - Times executed: 20 ]
[ Application: psql - Total duration: 3m46s - Times executed: 20 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 416); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01527);
Date: 2026-07-13 13:13:54 Duration: 1m52s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT RS_SETGLOBAL ('USUARIO', 398); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (04375);
Date: 2026-07-13 08:03:28 Duration: 20s531ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT RS_SETGLOBAL ('USUARIO', 398); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (04384);
Date: 2026-07-13 17:02:28 Duration: 17s889ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
12 152ms 43s886ms 7s535ms 45 5m39s select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 13 07 3 44s424ms 14s808ms 08 5 17s182ms 3s436ms 09 2 3s327ms 1s663ms 10 2 43s546ms 21s773ms 11 2 52s217ms 26s108ms 12 2 5s150ms 2s575ms 13 3 7s161ms 2s387ms 14 3 47s697ms 15s899ms 15 7 1m12s 10s308ms 16 2 11s314ms 5s657ms 17 14 34s912ms 2s493ms [ User: intelifix - Total duration: 5m39s - Times executed: 45 ]
[ Application: psql - Total duration: 5m39s - Times executed: 45 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (026960);
Date: 2026-07-13 14:46:30 Duration: 43s886ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (026931);
Date: 2026-07-13 07:16:17 Duration: 39s475ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (026946);
Date: 2026-07-13 10:59:53 Duration: 33s346ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
13 1s123ms 45s637ms 5s106ms 108 9m11s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 13 08 2 48s596ms 24s298ms 09 3 26s734ms 8s911ms 10 2 7s525ms 3s762ms 11 11 1m6s 6s80ms 12 7 18s558ms 2s651ms 13 2 4s415ms 2s207ms 14 17 1m 3s570ms 15 21 2m7s 6s65ms 16 20 1m55s 5s762ms 17 22 1m12s 3s287ms 18 1 3s133ms 3s133ms [ User: intelifix - Total duration: 9m11s - Times executed: 108 ]
[ Application: [unknown] - Total duration: 9m11s - Times executed: 108 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-13', 0395, '', '', 0, 6, '2026-07-01');
Date: 2026-07-13 08:30:51 Duration: 45s637ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-13', 099, '', '', 0, 6, '2026-07-01');
Date: 2026-07-13 16:32:30 Duration: 40s400ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-13', 0173, '', '', 0, 6, '2026-07-01');
Date: 2026-07-13 15:20:53 Duration: 38s346ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
14 158ms 21s807ms 3s886ms 91 5m53s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 13 00 1 599ms 599ms 07 10 54s52ms 5s405ms 08 12 1m3s 5s300ms 09 12 50s128ms 4s177ms 10 10 1m6s 6s618ms 11 10 1m2s 6s289ms 12 7 9s512ms 1s358ms 13 6 7s563ms 1s260ms 14 6 9s163ms 1s527ms 15 6 15s442ms 2s573ms 16 6 10s302ms 1s717ms 17 4 4s86ms 1s21ms 20 1 174ms 174ms [ User: intelifix - Total duration: 5m53s - Times executed: 91 ]
[ Application: psql - Total duration: 5m53s - Times executed: 91 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-13 11:25:23 Duration: 21s807ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-13 10:05:16 Duration: 14s862ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-13 07:35:14 Duration: 12s905ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
15 196ms 1m35s 3s495ms 51 2m58s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 13 07 6 6s540ms 1s90ms 08 4 2s434ms 608ms 09 3 11s798ms 3s932ms 10 4 24s139ms 6s34ms 11 7 2s631ms 375ms 12 3 1s791ms 597ms 13 1 8s393ms 8s393ms 14 3 6s324ms 2s108ms 15 11 1m39s 9s17ms 16 2 2s54ms 1s27ms 17 7 12s973ms 1s853ms [ User: intelifix - Total duration: 2m58s - Times executed: 51 ]
[ Application: psql - Total duration: 2m58s - Times executed: 51 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026969);
Date: 2026-07-13 15:25:57 Duration: 1m35s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT RS_SETGLOBAL ('USUARIO', 449); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026943);
Date: 2026-07-13 10:05:54 Duration: 12s852ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT RS_SETGLOBAL ('USUARIO', 449); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026942);
Date: 2026-07-13 09:53:36 Duration: 10s772ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
16 163ms 2m52s 3s204ms 270 14m25s call rs_giga_triagem (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 13 00 12 45s333ms 3s777ms 01 11 26s155ms 2s377ms 02 12 25s758ms 2s146ms 03 12 25s183ms 2s98ms 04 11 25s42ms 2s276ms 05 12 25s165ms 2s97ms 06 11 22s810ms 2s73ms 07 12 26s258ms 2s188ms 08 12 30s712ms 2s559ms 09 12 29s328ms 2s444ms 10 12 30s406ms 2s533ms 11 12 3m19s 16s637ms 12 12 27s310ms 2s275ms 13 12 28s368ms 2s364ms 14 12 29s728ms 2s477ms 15 12 34s935ms 2s911ms 16 12 42s538ms 3s544ms 17 12 31s167ms 2s597ms 18 12 27s715ms 2s309ms 19 12 30s329ms 2s527ms 20 10 47s419ms 4s741ms 21 12 27s22ms 2s251ms 22 11 26s997ms 2s454ms [ User: intelifix - Total duration: 14m25s - Times executed: 270 ]
[ Application: psql - Total duration: 14m25s - Times executed: 270 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-13 11:08:05 Duration: 2m52s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-13 00:05:23 Duration: 21s571ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-13 20:05:17 Duration: 13s646ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
17 736ms 1s997ms 1s217ms 173 3m30s create table temp0000226614 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 13 09 29 33s429ms 1s152ms 10 41 47s916ms 1s168ms 11 15 17s722ms 1s181ms 13 23 29s642ms 1s288ms 14 33 44s390ms 1s345ms 15 27 31s663ms 1s172ms 16 5 5s811ms 1s162ms [ User: intelifix - Total duration: 3m30s - Times executed: 173 ]
[ Application: [unknown] - Total duration: 3m30s - Times executed: 173 ]
-
CREATE TABLE temp0000226614 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"2", "cliente" :"0", "desde" :"08-07-2026", "ate" :"13-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-13 14:41:14 Duration: 1s997ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CREATE TABLE temp0000226614 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"2", "cliente" :"1", "desde" :"08-07-2026", "ate" :"13-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-13 13:36:15 Duration: 1s991ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CREATE TABLE temp0000226614 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"2", "cliente" :"0", "desde" :"08-07-2026", "ate" :"13-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-13 10:04:12 Duration: 1s886ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
18 150ms 7s123ms 1s164ms 1,745 33m51s select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 13 07 7 5s143ms 734ms 08 93 1m49s 1s172ms 09 172 2m55s 1s18ms 10 235 3m59s 1s20ms 11 184 3m4s 1s3ms 12 104 2m1s 1s164ms 13 143 2m16s 956ms 14 232 4m46s 1s235ms 15 207 4m51s 1s409ms 16 204 5m3s 1s487ms 17 164 2m57s 1s84ms [ User: intelifix - Total duration: 33m51s - Times executed: 1745 ]
[ Application: [unknown] - Total duration: 33m51s - Times executed: 1745 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (263251, 503, '7151638787H010901906,216562893755,216549396870,216753827192,216502508388,216410610925,216819198689,216909257490,216910554351,216790841636,216907935173,216562288588,216546048395,216799129616,184329975974,216505055057,216506405256,216907567280,216336657073,216817846975,216353333247,216410674062,216724122240,216834150004,216350694953,216865360727,216348586868,216413540717,216504622939,216515473650H010942423,216611360315,216814551436,216520126281,216336870002,216635478492,216833206061,216877517692,216866487794H010929170,216610035067,216410824458,216755961823', '',062,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-13 09:15:26 Duration: 7s123ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (265092, 304, '71716585850040302456,216791652534,216399994961,216836897274,216627199503,216816632626,216697675068,216519483839,216394285571,216753183639,216505995463,216607644048,216877591617,216360117578,216359637980,216799303247,216868461624,216410798394,216545862542,216697879914,216837382126,184271751729,216701428890,216738014549,216548338900,216832442542,216545267881,216503999511,216560922126,216837002134,216724401414,216561896373,216751257592,216835627891,216504942948,216876973240,216908167092H010987448,216634519599,216619146674,216408004755,216354517290', '',062,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-13 11:32:16 Duration: 6s911ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (265109, 304, 'CP2231LV0EE,4075C3296974$CP2238LV325,4075C3BFE2E8$CP2349LV172,400FC186A944$CP2347LV5PQ,400FC17DFE64$CP2111LV32S,08A7C04DD534$CP2432LV1JW,C4509CBEB45C$CP2346LV5HS,CCF3C897A354$CP2052LVEF2,484BD4AA7BCC$CP2127LV968,08A7C077D23C$CP2242LV41K,B85E71C7C34C$CP2240LVEBB,F8D2AC138908$CP2143LV503,1C9ECC8D523C$CP2146LV573,D4E2CB8DBB1C$CP2425LV1A3,C4509CAC90BC$CP2218LV1YK,00CB7ADD527C$CP2134LV3FW,ECA81F222D04$CP2051LV8N2,484BD4AA804C$CP2429LV6J4,C4509CBD4EFC$CP2526LV1UQ,B85E71115958$CP2046LV105,484BD48D5E7C$CP2226LV8VZ,80DAC2CF2424$CP2531LV3TS,3C82C08D6B10$CP2348LV4ZY,400FC1869984$CP2131LV96J,ECA81F19F8EC$CP2244LV0UG,B85E71D2B25C$CP2141LV45F,ECA81FF7ED8C$CP2240LV3M2,B85E71BFE3FC$CP2529LV36H,3C82C08D7CB8$CP2301LV46L,B85E71E77A5C$CP2528LV78L,F8D2AC4CE654$CP2242LVH0U,B85E71CAD2A8$CP2226LV6JJ,80DAC2CF7618$CP2218LV2W3,00CB7ADE8CDC$CP2302LV0LF,B85E71E66E14$CP2205LV8S1,3C82C06B8460$CP2134LV858,ECA81F234044$CP2347LVAN5,400FC1837914$CP2142LV5TV,ECA81FF79D04$CP2130LV31F,8C6A8DBE866C$CP2127LV1J9,08A7C075BC6C', '',0185,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-13 10:34:44 Duration: 6s457ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
19 150ms 15s964ms 1s133ms 155 2m55s select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 13 07 19 13s612ms 716ms 08 26 21s738ms 836ms 09 11 21s480ms 1s952ms 10 2 18s153ms 9s76ms 11 30 33s600ms 1s120ms 13 2 4s849ms 2s424ms 14 22 19s901ms 904ms 15 13 16s19ms 1s232ms 16 18 18s386ms 1s21ms 17 12 7s978ms 664ms [ User: intelifix - Total duration: 2m55s - Times executed: 155 ]
[ Application: [unknown] - Total duration: 2m55s - Times executed: 155 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (045286) LIMIT 1;
Date: 2026-07-13 09:59:01 Duration: 15s964ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (045285) LIMIT 1;
Date: 2026-07-13 10:00:47 Duration: 11s359ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (045288) LIMIT 1;
Date: 2026-07-13 10:00:11 Duration: 6s794ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
20 150ms 6s923ms 783ms 1,186 15m29s select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 13 08 110 1m37s 886ms 09 149 1m55s 776ms 10 190 2m25s 764ms 11 123 1m36s 780ms 12 1 1s155ms 1s155ms 13 142 1m55s 812ms 14 166 2m3s 746ms 15 187 2m18s 742ms 16 109 1m28s 807ms 17 9 7s153ms 794ms [ User: intelifix - Total duration: 15m29s - Times executed: 1186 ]
[ Application: [unknown] - Total duration: 15m29s - Times executed: 1186 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "103107", "modelo" : "287", "itens" : "229927648190,230004969811,229996529616,230012595168,229985409810,229997424058,229985327478,229930975979,229995361130,229937655576,229906090319,229960724550,229953430719,229991710426,229927792425,229969305466", "usuario" : "414", "caixa" : "1195710", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-13 13:57:43 Duration: 6s923ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "108194", "modelo" : "151", "itens" : "D86C5A56E338,C85D38FF6100,D86C5A5B16FA,C85D38816639,C85D38F7AD2F,C85D3869C2B2,D86C5A02D5A1,D86C5A67DCB0", "usuario" : "414", "caixa" : "1299288", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-13 15:20:48 Duration: 4s358ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "265249", "modelo" : "159", "itens" : "229762835574,229756297382,229682231827,229758172740,229680873445,229760367577,229681891536,229650673943,229682990218,229758090510,229682923443,229680024159,229650262534,229683873951,229682160103,216917591335,229650430912,229680548081,229681252629,229653372950,229682584162,229683360916,229653116583,229651631826,229652472828,229681135872,229654864857,229651449406,229681777887,229757043146,215861253640,229680923248,229757614144,229684069806,229679823354,229652087986,229759374866,229682325876,229653705866,229650967383,226881633252,229684301625,229650249299,229761621932,229654015167,229651011732,229683296868,229681686161", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-13 08:03:12 Duration: 3s586ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
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 13 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Jul 12 10 1 0ms 0ms 11 1 0ms 0ms 12 1 0ms 0ms 17 1 0ms 0ms 19 1 0ms 0ms 20 2 0ms 0ms 22 1 0ms 0ms Jul 13 09 1 0ms 0ms 15 1 0ms 0ms 20 1 0ms 0ms 22 1 0ms 0ms 23 1 0ms 0ms [ User: intelifix - Total duration: 14m56s - Times executed: 12 ]
[ User: lenon - Total duration: 533ms - Times executed: 1 ]
[ Application: psql - Total duration: 14m54s - Times executed: 10 ]
[ Application: [unknown] - Total duration: 2s709ms - Times executed: 3 ]
-
;
Date: Duration: 0ms Database: postgres User: rio Remote: intelifix Application: [local] Queryid: [unknown]
-
Events
Log levels
Key values
- 21,074 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 12 FATAL entries
- 4344 ERROR entries
- 0 WARNING entries
- 3 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 4,071 Max number of times the same event was reported
- 4,359 Total events found
Rank Times reported Error 1 4,071 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Jul 13 00 60 01 59 02 60 03 60 04 59 05 60 06 59 07 153 08 292 09 438 10 424 11 319 12 208 13 217 14 387 15 381 16 244 17 210 18 93 19 60 20 59 21 59 22 60 23 50 - ERROR: prepared statement "_PLAN0000000029D55FF0" does not exist
- ERROR: prepared statement "_PLAN0000000029F6BAE0" does not exist
- ERROR: prepared statement "_PLAN0000000029F6D640" does not exist
Statement: DEALLOCATE "_PLAN0000000029D55FF0"
Date: 2026-07-13 00:00:10 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-13.log
Statement: DEALLOCATE "_PLAN0000000029F6BAE0"
Date: 2026-07-13 00:01:11 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-13.log
Statement: DEALLOCATE "_PLAN0000000029F6D640"
Date: 2026-07-13 00:02:11 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-13.log
2 68 ERROR: update or delete on table "..." violates foreign key constraint "..." on table "..."
Times Reported Most Frequent Error / Event #2
Day Hour Count Jul 13 11 2 12 6 13 6 14 6 15 6 16 6 17 6 18 6 19 6 20 6 21 6 22 6 - ERROR: update or delete on table "fluxos" violates foreign key constraint "ref_caixa_itens_to_fluxos" on table "caixa_itens"
- ERROR: update or delete on table "fluxos" violates foreign key constraint "ref_caixa_itens_to_fluxos" on table "caixa_itens"
- ERROR: update or delete on table "fluxos" violates foreign key constraint "ref_caixa_itens_to_fluxos" on table "caixa_itens"
Detail: Key (flu_id)=(2957262) is still referenced from table "caixa_itens".
Context: SQL statement "DELETE FROM FLUXOS WHERE FLU_ID = nFluxo" PL/pgSQL function rs_triagem_exclui(integer,integer) line 121 at SQL statement PL/pgSQL function rs_processa_triagens_giga(integer) line 323 at assignment PL/pgSQL function rs_triagem_registra(character varying,integer,character varying,character varying,character varying,integer,character varying,character varying,character varying,character varying,character varying,character varying,character varying) line 75 at assignment PL/pgSQL function rs_giga_triagem(character varying,integer) line 192 at assignment SQL statement "CALL RS_GIGA_TRIAGEM( cNome, nAux )" PL/pgSQL function rs_giga_processa_arquivos() line 63 at CALL
Statement: CALL RS_GIGA_PROCESSA_ARQUIVOS()Date: 2026-07-13 11:45:16 Database: rio Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-13.log
Detail: Key (flu_id)=(2957262) is still referenced from table "caixa_itens".
Context: SQL statement "DELETE FROM FLUXOS WHERE FLU_ID = nFluxo" PL/pgSQL function rs_triagem_exclui(integer,integer) line 121 at SQL statement PL/pgSQL function rs_processa_triagens_giga(integer) line 323 at assignment PL/pgSQL function rs_triagem_registra(character varying,integer,character varying,character varying,character varying,integer,character varying,character varying,character varying,character varying,character varying,character varying,character varying) line 75 at assignment PL/pgSQL function rs_giga_triagem(character varying,integer) line 192 at assignment SQL statement "CALL RS_GIGA_TRIAGEM( cNome, nAux )" PL/pgSQL function rs_giga_processa_arquivos() line 63 at CALL
Statement: CALL RS_GIGA_PROCESSA_ARQUIVOS()Date: 2026-07-13 11:55:01 Database: rio Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-13.log
Detail: Key (flu_id)=(2957262) is still referenced from table "caixa_itens".
Context: SQL statement "DELETE FROM FLUXOS WHERE FLU_ID = nFluxo" PL/pgSQL function rs_triagem_exclui(integer,integer) line 121 at SQL statement PL/pgSQL function rs_processa_triagens_giga(integer) line 323 at assignment PL/pgSQL function rs_triagem_registra(character varying,integer,character varying,character varying,character varying,integer,character varying,character varying,character varying,character varying,character varying,character varying,character varying) line 75 at assignment PL/pgSQL function rs_giga_triagem(character varying,integer) line 192 at assignment SQL statement "CALL RS_GIGA_TRIAGEM( cNome, nAux )" PL/pgSQL function rs_giga_processa_arquivos() line 63 at CALL
Statement: CALL RS_GIGA_PROCESSA_ARQUIVOS()Date: 2026-07-13 12:05:01 Database: rio Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-13.log
3 46 ERROR: PermissionError: ... Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
Times Reported Most Frequent Error / Event #3
Day Hour Count Jul 13 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-13 00:05:02 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-13.log
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-13 00:35:01 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-13.log
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-13 01:05:01 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-13.log
4 45 ERROR: invalid input syntax for type json
Times Reported Most Frequent Error / Event #4
Day Hour Count Jul 13 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-13 08:00:08 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-13.log
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-13 08:20:07 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-13.log
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-13 08:40:03 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-13.log
5 35 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #5
Day Hour Count Jul 13 08 3 09 8 12 6 14 9 15 6 17 3 - ERROR: syntax error at or near ":" at character 29
- ERROR: syntax error at or near ":" at character 29
- ERROR: syntax error at or near ":" at character 29
Statement: SELECT * FROM RS_ETIQUETA(88:0F:A2:89:C3:E7)
Date: 2026-07-13 08:25:04 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-13.log
Statement: SELECT * FROM RS_ETIQUETA(88:0F:A2:89:C3:E7)
Date: 2026-07-13 08:25:04 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-13.log
Statement: SELECT * FROM RS_ETIQUETA(88:0F:A2:89:C3:E7)
Date: 2026-07-13 08:25:04 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-13.log
6 31 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #6
Day Hour Count Jul 13 05 4 18 27 - 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-13 05:32:10 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-13.log
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-13 05:32:10 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-13.log
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-13 05:32:10 Database: contagem Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-13.log
7 24 ERROR: unterminated quoted string at or near "..."
Times Reported Most Frequent Error / Event #7
Day Hour Count Jul 13 12 24 - ERROR: unterminated quoted string at or near "''');" at character 39
- ERROR: unterminated quoted string at or near "''');" at character 39
- ERROR: unterminated quoted string at or near "''');" at character 39
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA(''');
Date: 2026-07-13 12:03:27 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-13.log
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA(''');
Date: 2026-07-13 12:03:55 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-13.log
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA(''');
Date: 2026-07-13 12:04:58 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-13.log
8 10 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #8
Day Hour Count Jul 13 10 4 11 2 14 2 17 2 - ERROR: column "e0885da9a57c" does not exist at character 27
- ERROR: column "e0885da9a57c" does not exist at character 27
- ERROR: column "f8f53255ce53" does not exist at character 27
Statement: SELECT * FROM RS_ETIQUETA(E0885DA9A57C)
Date: 2026-07-13 10:24:39 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-13.log
Statement: SELECT * FROM RS_ETIQUETA(E0885DA9A57C)
Date: 2026-07-13 10:24:39 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-13.log
Statement: select * from rs_caixa_qr(F8F53255CE53)
Date: 2026-07-13 10:50:11 Database: brasilia Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-13.log
9 6 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #9
Day Hour Count Jul 13 03 6 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Context: PL/pgSQL expression "LPAD('',100,'=') || E'\n'" PL/pgSQL function rs_parametro(character varying) line 16 during statement block local variable initialization PL/pgSQL function rs_giga_tecnicos() line 16 during statement block local variable initialization
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-07-13 03:05:02 Database: rio Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-13.log
Date: 2026-07-13 03:05:02 Database: brasilia Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-13.log
Date: 2026-07-13 03:05:02 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-13.log
10 4 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #10
Day Hour Count Jul 13 00 1 03 2 06 1 - FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-07-13 00:02:19 Database: testes Application: [unknown] User: lenon Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-13.log
Date: 2026-07-13 03:20:05 Database: jaboatao Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-13.log
Date: 2026-07-13 03:20:20 Database: jaboatao Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-13.log
11 4 ERROR: trailing junk after numeric literal at or near "..."
Times Reported Most Frequent Error / Event #11
Day Hour Count Jul 13 14 1 15 3 - ERROR: trailing junk after numeric literal at or near "90AAC39D0350" at character 41
- ERROR: trailing junk after numeric literal at or near "82F503F9BC3F" at character 27
- ERROR: trailing junk after numeric literal at or near "82F503F9BC3F" at character 27
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA(''90AAC39D0350');
Date: 2026-07-13 14:38:41 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-13.log
Statement: SELECT * FROM RS_ETIQUETA(82F503F9BC3F)
Date: 2026-07-13 15:50:28 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-13.log
Statement: SELECT * FROM RS_ETIQUETA(82F503F9BC3F)
Date: 2026-07-13 15:50:29 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-13.log
12 4 ERROR: invalid byte sequence for encoding
Times Reported Most Frequent Error / Event #12
Day Hour Count Jul 13 15 4 - ERROR: invalid byte sequence for encoding "UTF8": 0x96
- ERROR: invalid byte sequence for encoding "UTF8": 0x96
- ERROR: invalid byte sequence for encoding "UTF8": 0x96
Date: 2026-07-13 15:15:54 Database: contagem Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-13.log
Date: 2026-07-13 15:15:54 Database: contagem Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-13.log
Date: 2026-07-13 15:16:19 Database: contagem Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-13.log
13 2 LOG: process ... still waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #13
Day Hour Count Jul 13 11 2 - LOG: process 3774973 still waiting for ShareLock on transaction 2557776 after 1000.071 ms
- LOG: process 3774973 still waiting for ShareLock on transaction 2557776 after 30243.468 ms
Detail: Process holding the lock: 3773126. Wait queue: 3774973.
Context: while updating tuple (73401,11) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-07-13 11:05:17 Database: rio Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-13.log
Detail: Process holding the lock: 3773126. Wait queue: 3774973.
Context: while updating tuple (73401,11) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-07-13 11:05:46 Database: rio Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-13.log
14 2 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #14
Day Hour Count Jul 13 03 2 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-07-13 03:05:02 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-13.log
Date: 2026-07-13 03:05:02 Database: brasilia Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-13.log
15 2 ERROR: function rs_lote_manutencao_itens(...) does not exist
Times Reported Most Frequent Error / Event #15
Day Hour Count Jul 13 09 2 - ERROR: function rs_lote_manutencao_itens(integer, integer, unknown, unknown, integer, integer, unknown, unknown, unknown, bigint) does not exist at character 15
- ERROR: function rs_lote_manutencao_itens(integer, integer, unknown, unknown, integer, integer, unknown, unknown, unknown, bigint) does not exist at character 15
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_LOTE_MANUTENCAO_ITENS(127705,397,'484070315252334,184227397287$483317314035971,184134533758$482145111579800,181223305665$483283313285055,184119823254$484007312157780,184174522947$483330313655758,184139939100$483214312558192,184104678789$483162312183234,184004485162$483309314823342,184132553643','',031,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":""}]','$$$$$$$$','',0184139939100);Date: 2026-07-13 09:30:51 Database: brasilia Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-13.log
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_LOTE_MANUTENCAO_ITENS(127705,397,'483309314823342,184132553643$483162312183234,184004485162$483214312558192,184104678789$483330313655758,184139939100$484007312157780,184174522947$483283313285055,184119823254$482145111579800,181223305665$483317314035971,184134533758$484070315252334,184227397287','',031,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":""}]','$$$$$$$$','',0184139939100);Date: 2026-07-13 09:31:37 Database: brasilia Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-13.log
16 2 ERROR: function rs_caixa_qr(...) does not exist
Times Reported Most Frequent Error / Event #16
Day Hour Count Jul 13 15 2 - ERROR: function rs_caixa_qr(numeric) does not exist at character 15
- ERROR: function rs_caixa_qr(numeric) does not exist at character 15
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: select * from rs_caixa_qr(379631379631379631379631)Date: 2026-07-13 15:14:54 Database: brasilia Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-13.log
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: select * from rs_caixa_qr(379631379631379631379631)Date: 2026-07-13 15:14:54 Database: brasilia Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-13.log
17 1 ERROR: function rs_fluxos_lista(...) does not exist
Times Reported Most Frequent Error / Event #17
Day Hour Count Jul 13 07 1 - ERROR: function rs_fluxos_lista(integer, integer, integer, unknown, unknown, bigint, unknown, integer) does not exist at character 46
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: CREATE TABLE temp0000285120 AS SELECT * FROM RS_FLUXOS_LISTA(06,00,0403,'13-07-2026','13-07-2026',0229995143151,'',00);Date: 2026-07-13 07:52:22 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-13.log
18 1 ERROR: canceling statement due to statement timeout
Times Reported Most Frequent Error / Event #18
Day Hour Count Jul 13 18 1 - ERROR: canceling statement due to statement timeout
Context: PL/pgSQL function rs_hex_to_int(character varying) line 24 at RETURN PL/pgSQL function rs_equipamento_senha(integer,character varying,character varying) line 112 at assignment PL/pgSQL function rs_equipamento_senha(character varying) line 105 at assignment PL/pgSQL function rs_etiqueta(character varying,integer,boolean) line 164 at assignment
Statement: SELECT "id", "cai_id", "lot_id", "lot_tipo", "lot_notafiscal", "ofi_nome", "cli_nome", "usu_nome", "mod_nome", "mod_mnemonico", "fabricante", "mac_address", "part_number", "barra1", "barra2", "barra3", "barra4", "corrigido1", "corrigido2", "corrigido3", "corrigido4", "extra1", "extra2", "extra3", "extra4", "nf_entrada", "valor", "motivo", "acessorio1", "acessorio2", "acessorio3", "acessorio4", "ssid", "ssid_5g", "senha", "senha_5g", "senha_admin", "user_admin", "modelo_legado", "legado1", "legado2", "legado3", "legado4", "sap", "sap1", "sap2", "material", "firmware", "serial", "caid", "macaddress", "end_principal", "ns", "temporario", "qr_code", "qr_code1", "qr_code2", "itens_caixa", "mac_4", "end_princ6", "end_princ6_5g" FROM "public"."rs_equipamento_etiquetas"Date: 2026-07-13 18:23:26 Database: brasilia Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-13.log
19 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #19
Day Hour Count Jul 13 03 1 - LOG: database system was shut down at 2026-07-13 03:05:02 -03
Date: 2026-07-13 03:05:04 Log file: /usr/local/pgsql/data/log/serverlog-13.log