pgBadger-
Global information
- Generated on Fri Aug 7 23:50:10 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 36,973 log entries in 9s
- Log start from 2026-08-07 00:00:41 to 2026-08-07 23:49:55
-
Overview
Global Stats
- 353 Number of unique normalized queries
- 5,784 Number of queries
- 7h48m31s Total query duration
- 2026-08-07 00:02:09 First query
- 2026-08-07 23:49:12 Last query
- 7 queries/s at 2026-08-07 09:18:30 Query peak
- 7h48m31s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 7h48m31s Execute total duration
- 3,053 Number of events
- 16 Number of unique normalized events
- 2,960 Max number of times the same event was reported
- 0 Number of cancellation
- 500 Total number of automatic vacuums
- 948 Total number of automatic analyzes
- 12 Number temporary file
- 239.36 MiB Max size of temporary file
- 110.05 MiB Average size of temporary file
- 348 Total number of sessions
- 7 sessions at 2026-08-07 07:01:19 Session peak
- 12d23h36s Total duration of sessions
- 53m37s Average duration of sessions
- 16 Average queries per session
- 1m20s Average queries duration per session
- 52m16s Average idle time per session
- 360 Total number of connections
- 4 connections/s at 2026-08-07 00:05:02 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 7 queries/s Query Peak
- 2026-08-07 09:18:30 Date
SELECT Traffic
Key values
- 6 queries/s Query Peak
- 2026-08-07 09:18:30 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 4 queries/s Query Peak
- 2026-08-07 23:48:59 Date
Queries duration
Key values
- 7h48m31s 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) Aug 07 00 29 0ms 22s905ms 4s615ms 5s904ms 7s197ms 1m30s 01 35 0ms 3s842ms 1s193ms 4s920ms 6s342ms 7s456ms 02 19 0ms 3s998ms 2s29ms 4s131ms 6s672ms 7s341ms 03 28 0ms 6s873ms 1s793ms 5s928ms 7s448ms 12s636ms 04 26 0ms 4s615ms 1s680ms 5s203ms 6s550ms 9s209ms 05 36 0ms 10m20s 34s961ms 10s83ms 2m41s 10m20s 06 38 0ms 21s967ms 2s954ms 4s355ms 20s593ms 30s338ms 07 559 151ms 9m26s 3s937ms 57s920ms 4m41s 9m29s 08 663 150ms 9m48s 4s814ms 2m13s 6m16s 9m54s 09 561 150ms 9m12s 4s540ms 1m25s 5m28s 9m18s 10 485 150ms 8m22s 5s532ms 1m26s 6m20s 8m24s 11 489 150ms 10m15s 4s343ms 49s806ms 5m42s 10m31s 12 140 0ms 9m5s 8s24ms 12s154ms 1m47s 9m6s 13 538 0ms 6m9s 2s267ms 31s790ms 1m19s 6m46s 14 637 0ms 7m42s 2s270ms 32s182ms 1m33s 8m14s 15 427 0ms 8m53s 3s777ms 59s233ms 3m11s 8m57s 16 247 0ms 6m11s 3s413ms 9s513ms 1m13s 6m11s 17 191 0ms 6m13s 4s544ms 16s89ms 25s329ms 6m47s 18 76 0ms 5m47s 10s137ms 20s880ms 46s794ms 5m47s 19 24 0ms 5m37s 26s653ms 6s839ms 48s266ms 5m37s 20 117 0ms 8m28s 12s708ms 1m5s 2m11s 8m28s 21 40 0ms 6m4s 17s18ms 7s673ms 10s182ms 6m55s 22 31 0ms 5m52s 21s95ms 7s624ms 47s975ms 5m52s 23 348 0ms 1m27s 6s725ms 1m7s 1m10s 1m29s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 07 00 7 0 1s859ms 0ms 0ms 1s238ms 01 17 0 347ms 150ms 397ms 851ms 02 2 0 422ms 0ms 0ms 0ms 03 9 0 276ms 0ms 150ms 542ms 04 7 0 335ms 0ms 170ms 337ms 05 14 0 322ms 0ms 233ms 1s95ms 06 19 0 1s41ms 0ms 883ms 3s670ms 07 436 0 3s998ms 13s556ms 37s816ms 6m48s 08 516 0 4s853ms 13s6ms 2m12s 6m16s 09 417 0 4s289ms 11s416ms 44s768ms 6m2s 10 374 0 5s438ms 16s662ms 45s573ms 6m27s 11 383 0 4s783ms 16s210ms 21s185ms 7m12s 12 91 0 11s274ms 2s714ms 6s364ms 4m56s 13 412 0 2s424ms 9s480ms 26s837ms 3m56s 14 531 0 2s416ms 11s500ms 23s863ms 5m39s 15 319 0 4s496ms 12s845ms 33s890ms 5m5s 16 185 0 4s216ms 4s201ms 5s424ms 3m58s 17 119 0 6s717ms 3s166ms 9s245ms 4m10s 18 38 0 18s487ms 0ms 15s383ms 3m32s 19 6 0 1m38s 0ms 0ms 3m26s 20 12 87 14s458ms 26s743ms 1m5s 4m10s 21 18 0 34s355ms 0ms 771ms 3m18s 22 7 0 1m24s 0ms 0ms 3m12s 23 20 326 6s760ms 1m3s 1m7s 1m27s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 07 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 Aug 07 00 0 1 1.00 0.00% 01 0 2 2.00 0.00% 02 0 1 1.00 0.00% 03 0 2 2.00 0.00% 04 0 1 1.00 0.00% 05 0 2 2.00 0.00% 06 0 3 3.00 0.00% 07 0 10 10.00 0.00% 08 0 11 11.00 0.00% 09 0 15 15.00 0.00% 10 0 11 11.00 0.00% 11 0 12 12.00 0.00% 12 0 5 5.00 0.00% 13 0 13 13.00 0.00% 14 0 7 7.00 0.00% 15 0 8 8.00 0.00% 16 0 5 5.00 0.00% 17 0 5 5.00 0.00% 18 0 1 1.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 3 3.00 0.00% 22 0 0 0.00 0.00% 23 0 2 2.00 0.00% Day Hour Count Average / Second Aug 07 00 15 0.00/s 01 7 0.00/s 02 11 0.00/s 03 17 0.00/s 04 9 0.00/s 05 10 0.00/s 06 21 0.01/s 07 17 0.00/s 08 22 0.01/s 09 25 0.01/s 10 19 0.01/s 11 21 0.01/s 12 11 0.00/s 13 22 0.01/s 14 14 0.00/s 15 19 0.01/s 16 19 0.01/s 17 15 0.00/s 18 9 0.00/s 19 10 0.00/s 20 13 0.00/s 21 11 0.00/s 22 9 0.00/s 23 14 0.00/s Day Hour Count Average Duration Average idle time Aug 07 00 5 1h36s 1h9s 01 14 1h1m15s 1h1m12s 02 7 1h 59m54s 03 18 23m46s 23m43s 04 9 1h2m40s 1h2m35s 05 10 55m36s 53m30s 06 9 58m40s 58m28s 07 18 51m43s 49m40s 08 16 52m50s 49m30s 09 26 50m46s 49m8s 10 22 55m39s 53m37s 11 20 55m50s 54m4s 12 18 59m27s 58m25s 13 11 59m48s 57m57s 14 20 1h32s 59m20s 15 17 52m31s 50m56s 16 19 53m18s 52m33s 17 19 52m26s 51m41s 18 12 1h6s 59m2s 19 9 1h 58m49s 20 13 47m32s 45m38s 21 10 1h 58m52s 22 11 1h16s 59m17s 23 15 38m48s 36m12s -
Connections
Established Connections
Key values
- 4 connections Connection Peak
- 2026-08-07 00:05:02 Date
Connections per database
Key values
- rio Main Database
- 360 connections Total
Connections per user
Key values
- intelifix Main User
- 360 connections Total
-
Sessions
Simultaneous sessions
Key values
- 7 sessions Session Peak
- 2026-08-07 07:01:19 Date
Histogram of session times
Key values
- 285 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 348 sessions Total
Sessions per user
Key values
- intelifix Main User
- 348 sessions Total
Sessions per host
Key values
- [local] Main Host
- 348 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 18,431 buffers Checkpoint Peak
- 2026-08-07 00:19:42 Date
- 270.022 seconds Highest write time
- 1.032 seconds Sync time
Checkpoints Wal files
Key values
- 11 files Wal files usage Peak
- 2026-08-07 10:34:36 Date
Checkpoints distance
Key values
- 380.70 Mo Distance Peak
- 2026-08-07 10:34:36 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Aug 07 00 34,049 658.113s 0.111s 658.345s 01 3,041 305.388s 0.202s 305.716s 02 1,493 150.04s 0.092s 150.177s 03 2,653 265.366s 0.046s 265.471s 04 3,296 331.046s 0.3s 331.415s 05 9,833 968.142s 0.285s 968.508s 06 4,051 269.754s 0.004s 269.769s 07 31,931 2,570.035s 0.456s 2,570.661s 08 66,530 3,238.68s 1.772s 3,240.706s 09 61,553 3,238.648s 0.809s 3,239.691s 10 68,757 3,235.376s 0.748s 3,236.438s 11 43,914 3,183.955s 0.64s 3,184.844s 12 13,358 1,344.562s 0.233s 1,344.967s 13 34,670 2,574.48s 0.792s 2,575.438s 14 38,645 2,923.668s 0.578s 2,924.437s 15 33,800 2,908.627s 0.414s 2,909.196s 16 17,154 1,396.775s 0.493s 1,397.374s 17 19,942 1,315.49s 0.448s 1,316.045s 18 13,107 629.603s 0.03s 629.677s 19 23 2.328s 0.005s 2.339s 20 1,680 172.792s 0.016s 172.832s 21 3,032 304.906s 0.098s 305.156s 22 2,486 249.558s 0.117s 249.761s 23 351 35.286s 0.025s 35.348s Day Hour Added Removed Recycled Synced files Longest sync Average sync Aug 07 00 0 0 7 494 0.064s 0.006s 01 0 0 1 607 0.064s 0.021s 02 0 0 1 335 0.064s 0.006s 03 0 0 1 512 0.005s 0.008s 04 0 0 1 707 0.065s 0.009s 05 0 0 4 803 0.045s 0.016s 06 0 0 1 9 0.001s 0.001s 07 0 0 27 3,704 0.063s 0.012s 08 0 0 49 6,271 0.968s 0.013s 09 0 0 53 6,725 0.050s 0.012s 10 0 0 52 5,943 0.043s 0.012s 11 0 0 25 5,313 0.063s 0.012s 12 0 0 4 2,556 0.064s 0.012s 13 0 0 17 5,837 0.062s 0.012s 14 0 0 22 5,751 0.076s 0.012s 15 0 0 17 4,847 0.058s 0.012s 16 0 0 4 3,060 0.217s 0.012s 17 0 0 8 2,715 0.064s 0.011s 18 0 0 10 571 0.002s 0.003s 19 0 0 0 3 0.003s 0.002s 20 0 0 1 79 0.002s 0.003s 21 0 0 0 401 0.065s 0.024s 22 0 0 1 432 0.064s 0.021s 23 0 0 0 31 0.005s 0.006s Day Hour Count Avg time (sec) Aug 07 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 Aug 07 00 20,444.83 kB 63,047.17 kB 01 1,671.00 kB 34,703.00 kB 02 1,332.83 kB 16,223.17 kB 03 1,661.75 kB 3,229.38 kB 04 1,925.56 kB 3,440.56 kB 05 7,540.40 kB 16,104.20 kB 06 8,297.00 kB 13,050.00 kB 07 36,839.67 kB 76,953.33 kB 08 67,453.58 kB 109,639.50 kB 09 72,470.08 kB 134,512.83 kB 10 71,321.58 kB 147,217.83 kB 11 33,140.92 kB 89,737.08 kB 12 5,601.42 kB 50,531.50 kB 13 23,604.67 kB 35,613.83 kB 14 29,513.75 kB 65,975.83 kB 15 22,975.17 kB 39,717.17 kB 16 6,783.58 kB 22,769.25 kB 17 11,278.64 kB 33,386.82 kB 18 52,113.33 kB 57,574.67 kB 19 180.00 kB 72,044.00 kB 20 5,080.67 kB 59,749.00 kB 21 1,977.00 kB 36,714.86 kB 22 1,045.00 kB 14,949.42 kB 23 259.00 kB 6,154.80 kB -
Temporary Files
Size of temporary files
Key values
- 478.72 MiB Temp Files size Peak
- 2026-08-07 05:32:10 Date
Number of temporary files
Key values
- 2 per second Temp Files Peak
- 2026-08-07 05:30:42 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Aug 07 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 10 1.09 GiB 111.26 MiB 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 2 208.00 MiB 104.00 MiB 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 929.78 MiB 71.39 MiB 239.36 MiB 116.22 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-07 05:32:19 Duration: 1m33s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-07 05:32:10 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 2 208.00 MiB 104.00 MiB 104.00 MiB 104.00 MiB select * from rs_fast_excel (?, ?);-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028193, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-07 11:46:57 Duration: 7m7s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028150, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-07 07:35:44 Duration: 6m45s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028190, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-07 10:36:45 Duration: 6m24s Database: rio User: intelifix Remote: [local] Application: [unknown]
3 2 182.80 MiB 91.40 MiB 91.40 MiB 91.40 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-07 05:30:45 Duration: 43s96ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-07 05:30:42 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
Queries generating the largest temporary files
Rank Size Query 1 239.36 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-07 05:32:10 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 239.36 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-07 05:32:10 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_exclui_seriais(''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_83.xlsx');[ Date: 2026-08-07 15:17:25 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
4 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-08-07 15:21:16 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
5 91.40 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-08-07 05:30:42 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 91.40 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-08-07 05:30:42 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 78.99 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-07 05:32:18 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 78.91 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-07 05:32:15 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 78.91 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-07 05:32:16 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 71.47 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-07 05:32:19 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 71.39 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-07 05:32:16 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 71.39 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-07 05:32:18 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 19.11 sec Highest CPU-cost vacuum
Table public.giga_testes
Database rio - 2026-08-07 11:45:51 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 19.11 sec Highest CPU-cost vacuum
Table public.giga_testes
Database rio - 2026-08-07 11:45:51 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (83) Main table analyzed (database rio)
- 948 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 83 brasilia.pg_catalog.pg_attribute 57 rio.pg_catalog.pg_class 43 rio.public.usuarios 38 rio.pg_catalog.pg_type 37 rio.public.temp0000287753 33 brasilia.pg_catalog.pg_class 32 rio.public.temp0000287771 29 brasilia.pg_catalog.pg_type 29 contagem.pg_catalog.pg_attribute 29 contagem.public.temp0000226790 28 rio.public.temp0000287783 25 contagem.pg_catalog.pg_class 24 rio.pg_catalog.pg_index 24 contagem.pg_catalog.pg_type 22 brasilia.pg_catalog.pg_index 21 rio.pg_catalog.pg_depend 20 contagem.public.temp0000226788 19 rio.public.temp0000287312 18 brasilia.public.temp0000237762 18 brasilia.pg_catalog.pg_depend 18 contagem.pg_catalog.pg_index 16 contagem.public.temp0000226794 16 contagem.pg_catalog.pg_depend 15 rio.public.temp0000287785 15 brasilia.public.temp0000237748 14 rio.public.temp0000287751 14 contagem.public.nf_entrada 11 brasilia.public.temp0000237760 11 brasilia.public.usuarios 10 contagem.public.usuarios 10 rio.public.temp0000287737 9 rio.public.temp0000287306 8 rio.public.temp0000287811 7 brasilia.public.nf_entrada 7 brasilia.public.temp0000237770 7 rio.public.temp0000287388 6 brasilia.public.temp0000237756 6 rio.public.temp0000287821 6 rio.public.temp0000287749 6 brasilia.public.temp0000237772 5 rio.public.temp0000287761 4 rio.public.temp0000287651 4 postgres.pg_catalog.pg_shdepend 4 brasilia.pg_catalog.pg_shdepend 4 contagem.pg_catalog.pg_shdepend 4 rio.public.temp0000287827 4 brasilia.auditor.auditor_2026_08 3 rio.public.tmp_drill_0302 3 brasilia.public.temp0000237766 3 rio.public.temp0000287839 3 rio.public.temp0000287741 3 rio.public.temp0000287795 3 rio.pg_catalog.pg_shdepend 3 brasilia.public.temp0000237736 3 rio.public.temp0000287815 3 template1.pg_catalog.pg_shdepend 3 contagem.public.temp0000226778 3 rio.public.temp0000287841 2 contagem.auditor.auditor_2026_08 2 rio.public.temp0000287765 2 brasilia.public.temp0000237730 2 rio.public.temp0000287406 2 brasilia.public.temp0000237758 2 rio.public.temp0000287703 2 brasilia.public.temp0000237698 2 contagem.public.temp0000226792 2 brasilia.public.temp0000237786 2 rio.public.temp0000287755 1 contagem.public.temp0000226786 1 rio.public.temp0000287787 1 rio.public.temp0000287797 1 rio.public.temp0000287410 1 rio.public.temp0000287757 1 rio.public.temp0000287829 1 brasilia.public.temp0000237700 1 brasilia.public.temp0000237702 1 brasilia.public.temp0000237738 1 rio.public.temp0000287775 1 rio.public.temp0000287781 1 brasilia.public.temp0000237722 1 brasilia.public.temp0000237704 1 brasilia.public.temp0000237714 1 rio.auditor.auditor_2026_08 1 rio.public.temp0000287769 1 brasilia.public.temp0000237764 1 rio.public.temp0000287803 1 rio.public.tmp_drill_0320 1 rio.public.temp0000287819 1 brasilia.public.temp0000237696 1 contagem.public.temp0000226764 1 brasilia.public.temp0000237728 1 rio.public.temp0000287835 1 Total 948 Vacuums per table
Key values
- pg_catalog.pg_attribute (42) Main table vacuumed on database rio
- 500 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 42 29 0 0 0 0 0 16,067 4,832 7,096,357 260 6,601 rio.pg_catalog.pg_class 38 21 0 0 0 0 0 4,002 1,304 1,882,515 69 254 rio.public.temp0000287771 30 0 0 0 0 0 0 28,417 1,930 4,071,673 0 0 rio.pg_catalog.pg_type 26 15 0 0 0 0 0 1,558 535 658,947 63 195 rio.public.temp0000287783 25 0 0 0 0 0 0 25,728 92 1,534,955 0 0 brasilia.pg_catalog.pg_attribute 22 22 0 0 0 0 0 14,980 2,472 4,917,280 86 2,434 brasilia.pg_catalog.pg_class 16 16 0 0 0 0 0 3,955 643 1,195,767 33 124 rio.public.temp0000287312 16 0 0 0 0 0 0 551 89 44,694 0 0 rio.public.temp0000287753 16 0 0 0 0 0 0 7,684 85 466,413 0 0 contagem.public.temp0000226794 16 0 0 0 0 0 0 1,638 298 454,261 0 0 contagem.pg_catalog.pg_attribute 16 16 0 0 0 0 0 10,544 2,245 4,204,733 44 764 contagem.pg_catalog.pg_class 14 14 0 0 0 0 0 2,967 516 888,932 14 52 brasilia.pg_catalog.pg_type 14 14 0 0 0 0 0 1,633 299 470,901 25 74 rio.pg_catalog.pg_index 14 13 0 0 0 0 0 886 294 270,109 39 94 brasilia.public.temp0000237748 11 0 0 0 0 0 0 2,478 783 1,279,657 0 0 contagem.public.usuarios 11 0 0 0 0 0 0 44 34 20,963 2 2 contagem.pg_catalog.pg_type 11 11 0 0 0 0 0 1,360 351 597,577 9 26 rio.public.temp0000287785 11 0 0 0 0 0 0 804 63 56,830 0 0 rio.pg_catalog.pg_depend 9 8 0 0 0 0 0 2,617 1,035 1,394,678 48 414 contagem.pg_catalog.pg_depend 8 8 0 0 0 0 0 2,456 727 1,437,353 14 117 contagem.pg_catalog.pg_index 8 8 0 0 0 0 0 538 173 170,327 9 14 rio.public.temp0000287306 7 0 0 0 0 0 0 415 41 30,394 0 0 rio.public.temp0000287811 7 0 0 0 0 0 0 417 31 29,295 0 0 brasilia.pg_catalog.pg_index 7 7 0 0 0 0 0 572 99 120,665 16 36 rio.public.tmp_drill_0302 7 2 0 0 0 0 0 96 8 19,169 0 0 rio.public.temp0000287821 6 0 0 0 0 0 0 557 124 193,686 0 0 rio.public.temp0000287388 6 0 0 0 0 0 0 342 33 25,029 0 0 brasilia.pg_catalog.pg_depend 6 6 0 0 0 0 0 2,319 501 898,462 19 162 rio.pg_catalog.pg_statistic 5 5 0 0 0 0 0 7,301 2,315 9,053,284 1,466 7,327 rio.public.usuarios 5 5 0 0 0 0 0 126 37 60,879 5 5 brasilia.pg_catalog.pg_shdepend 5 5 0 0 0 0 0 688 196 316,475 31 62 brasilia.pg_catalog.pg_statistic 4 4 0 0 0 0 0 4,594 1,694 5,879,016 1,306 7,839 rio.public.temp0000287651 4 0 0 0 0 0 0 1,731 17 104,938 0 0 brasilia.public.temp0000237756 4 0 0 0 0 0 0 988 24 62,881 0 0 rio.public.temp0000287827 4 0 0 0 0 0 0 395 24 27,024 0 0 rio.public.temp0000287795 3 0 0 0 0 0 0 3,428 11 203,996 0 0 rio.pg_toast.pg_toast_2619 3 3 0 0 0 0 0 1,581 446 2,127,659 156 486 rio.public.temp0000287839 3 0 0 0 0 0 0 5,141 12 305,128 0 0 brasilia.public.temp0000237766 3 0 0 0 0 0 0 741 258 422,008 0 0 postgres.pg_catalog.pg_shdepend 3 3 0 0 0 0 0 377 109 210,107 15 24 brasilia.pg_toast.pg_toast_2619 3 3 0 0 0 0 0 512 163 530,195 29 63 contagem.auditor.auditor_2026_08 2 0 0 0 0 0 0 15,911 9,876 13,258,280 2,553 74,811 contagem.public.nf_entrada 2 2 0 0 0 0 0 254 138 248,679 14 26 template1.pg_catalog.pg_shdepend 2 2 0 0 0 0 0 295 98 154,675 25 69 contagem.pg_catalog.pg_statistic 2 2 0 0 0 0 0 2,869 245 1,042,239 190 1,665 rio.public.temp0000287749 2 0 0 0 0 0 0 1,799 10 107,662 0 0 brasilia.public.temp0000237786 2 0 0 0 0 0 0 495 12 31,505 0 0 brasilia.public.nf_entrada 2 2 0 0 0 0 0 414 211 404,271 13 25 brasilia.public.temp0000237730 2 0 0 0 0 0 0 494 12 31,440 0 0 brasilia.public.temp0000237704 1 0 0 0 0 0 0 8 6 1,741 0 0 rio.public.temp0000287769 1 0 0 0 0 0 0 88 6 6,109 0 0 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 154 4 22,915 0 0 rio.public.temp0000287755 1 0 0 0 0 0 0 8 5 1,307 0 0 rio.auditor.auditor_2026_08 1 0 0 0 0 0 0 24,167 17,097 21,906,938 3,439 69,243 rio.public.giga_testes 1 1 0 0 0 0 0 32,610 25,177 76,579,668 421 8,580 rio.public.temp0000287787 1 0 0 0 0 0 0 90 6 6,232 0 0 brasilia.auditor.auditor_2026_08 1 0 0 0 0 0 0 14,645 7,451 10,179,005 3,559 84,444 rio.public.tmp_drill_0320 1 1 0 0 0 0 0 23 3 5,533 0 0 rio.public.temp0000287757 1 0 0 0 0 0 0 8 5 1,307 0 0 rio.public.temp0000287803 1 0 0 0 0 0 0 8 5 1,223 0 0 rio.public.temp0000287819 1 0 0 0 0 0 0 100 6 6,840 0 0 rio.public.temp0000287829 1 0 0 0 0 0 0 100 6 6,840 0 0 rio.public.temp0000287835 1 0 0 0 0 0 0 4 3 774 0 0 rio.public.temp0000287781 1 0 0 0 0 0 0 88 6 6,110 0 0 Total 500 249 0 0 0 0 0 257,860 85,331 177,746,505 13,972 266,032 Vacuum throughput per table
Key values
- public.giga_testes (19.11) 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 2.89 rio.pg_catalog.pg_class 0 0 1.19 rio.public.temp0000287771 0 0 1.11 rio.pg_catalog.pg_type 0 0 0.29 rio.public.temp0000287783 0 0 1.23 brasilia.pg_catalog.pg_attribute 0 0 1.55 brasilia.pg_catalog.pg_class 0 0 0.57 rio.public.temp0000287312 0 0 0.19 rio.public.temp0000287753 0 0 0.34 contagem.public.temp0000226794 0 0 0.22 contagem.pg_catalog.pg_attribute 0 0 1.25 contagem.pg_catalog.pg_class 0 0 0.31 brasilia.pg_catalog.pg_type 0 0 0.19 rio.pg_catalog.pg_index 0 0 0.3 brasilia.public.temp0000237748 0 0 0.24 contagem.public.usuarios 0 0 0 contagem.pg_catalog.pg_type 0 0 0.31 rio.public.temp0000287785 0 0 0.14 rio.pg_catalog.pg_depend 0 0 0.62 contagem.pg_catalog.pg_depend 0 0 0.41 contagem.pg_catalog.pg_index 0 0 0.11 rio.public.temp0000287306 0 0 0.1 rio.public.temp0000287811 0 0 0.03 brasilia.pg_catalog.pg_index 0 0 0.07 rio.public.tmp_drill_0302 0 0 0 rio.public.temp0000287821 0 0 0.1 rio.public.temp0000287388 0 0 0.07 brasilia.pg_catalog.pg_depend 0 0 0.33 rio.pg_catalog.pg_statistic 0 0 0.86 rio.public.usuarios 0 0 0 brasilia.pg_catalog.pg_shdepend 0 0 0.13 brasilia.pg_catalog.pg_statistic 0 0 0.38 rio.public.temp0000287651 0 0 0.12 brasilia.public.temp0000237756 0 0 0.07 rio.public.temp0000287827 0 0 0.07 rio.public.temp0000287795 0 0 0.14 rio.pg_toast.pg_toast_2619 0 0 0.13 rio.public.temp0000287839 0 0 0.16 brasilia.public.temp0000237766 0 0 0.06 postgres.pg_catalog.pg_shdepend 0 0 0.06 brasilia.pg_toast.pg_toast_2619 0 0 0.04 contagem.auditor.auditor_2026_08 0 0 3.13 contagem.public.nf_entrada 0 0 0.06 template1.pg_catalog.pg_shdepend 0 0 0.19 contagem.pg_catalog.pg_statistic 0 0 0.16 rio.public.temp0000287749 0 0 0.05 brasilia.public.temp0000237786 0 0 0.03 brasilia.public.nf_entrada 0 0 0.1 brasilia.public.temp0000237730 0 0 0.04 brasilia.public.temp0000237704 0 0 0.02 rio.public.temp0000287769 0 0 0.01 contagem.pg_toast.pg_toast_2619 0 0 0 rio.public.temp0000287755 0 0 0.02 rio.auditor.auditor_2026_08 0 0 6.65 rio.public.giga_testes 0 0 19.11 rio.public.temp0000287787 0 0 0.01 brasilia.auditor.auditor_2026_08 0 0 3.15 rio.public.tmp_drill_0320 0 0 0 rio.public.temp0000287757 0 0 0.01 rio.public.temp0000287803 0 0 0.01 rio.public.temp0000287819 0 0 0.02 rio.public.temp0000287829 0 0 0.01 rio.public.temp0000287835 0 0 0.05 rio.public.temp0000287781 0 0 0.02 Total 0 0 49.23 Tuples removed per table
Key values
- pg_catalog.pg_attribute (141061) Main table with removed tuples on database brasilia
- 446828 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain brasilia.pg_catalog.pg_attribute 22 22 141,061 497,166 672 726 13,222 rio.pg_catalog.pg_attribute 42 29 127,623 1,090,626 132,259 275 25,600 contagem.pg_catalog.pg_attribute 16 16 84,780 381,922 68 110 9,551 rio.pg_catalog.pg_statistic 5 5 9,797 40,671 119 0 6,430 brasilia.pg_catalog.pg_class 16 16 9,322 60,288 56 197 2,198 rio.pg_catalog.pg_depend 9 8 7,105 175,635 4,693 0 1,683 brasilia.pg_catalog.pg_type 14 14 7,006 31,306 0 75 1,048 brasilia.pg_catalog.pg_statistic 4 4 6,730 33,765 0 0 4,288 contagem.pg_catalog.pg_type 11 11 5,812 24,795 2 27 805 contagem.pg_catalog.pg_statistic 2 2 5,478 14,967 0 0 2,022 rio.pg_catalog.pg_type 26 15 4,864 68,834 9,736 9 1,879 brasilia.pg_catalog.pg_shdepend 5 5 4,601 68,343 368 0 595 brasilia.pg_catalog.pg_index 7 7 4,301 13,246 0 15 424 rio.pg_catalog.pg_class 38 21 3,686 161,067 30,605 53 4,881 contagem.pg_catalog.pg_depend 8 8 3,603 149,042 12 14 1,452 rio.pg_catalog.pg_index 14 13 3,044 28,302 1,413 10 802 postgres.pg_catalog.pg_shdepend 3 3 2,983 41,573 740 0 357 brasilia.pg_catalog.pg_depend 6 6 2,957 105,458 6 31 1,150 contagem.pg_catalog.pg_index 8 8 2,860 15,199 2 5 466 template1.pg_catalog.pg_shdepend 2 2 1,622 27,461 327 0 238 rio.public.giga_testes 1 1 1,382 3,834,687 19 0 102,527 brasilia.public.nf_entrada 2 2 1,081 8,600 0 0 304 rio.pg_toast.pg_toast_2619 3 3 1,019 2,070 0 0 819 contagem.public.nf_entrada 2 2 826 2,550 0 0 158 rio.public.tmp_drill_0302 7 2 795 10,508 4,704 0 152 contagem.pg_catalog.pg_class 14 14 789 49,951 7 76 1,782 contagem.public.usuarios 11 0 653 264 0 0 22 rio.public.usuarios 5 5 321 3,043 498 0 85 brasilia.pg_toast.pg_toast_2619 3 3 312 400 0 0 210 brasilia.auditor.auditor_2026_08 1 0 155 1,099,704 0 0 49,644 contagem.pg_toast.pg_toast_2619 1 1 140 114 0 0 59 rio.auditor.auditor_2026_08 1 0 120 3,980,684 0 0 191,512 brasilia.public.temp0000237704 1 0 0 3,188 0 17 239 rio.public.temp0000287795 3 0 0 72,391 0 0 5,184 rio.public.temp0000287769 1 0 0 1,383 0 48 80 rio.public.temp0000287821 6 0 0 22,574 0 259 509 rio.public.temp0000287755 1 0 0 1,383 0 48 80 brasilia.public.temp0000237748 11 0 0 35,088 0 187 2,629 rio.public.temp0000287306 7 0 0 17,505 0 247 393 rio.public.temp0000287811 7 0 0 19,779 0 126 450 contagem.auditor.auditor_2026_08 2 0 0 1,662,255 0 0 75,024 rio.public.temp0000287787 1 0 0 1,444 0 46 82 rio.public.temp0000287312 16 0 0 32,600 0 440 680 rio.public.temp0000287388 6 0 0 14,875 0 147 333 rio.public.temp0000287783 25 0 0 603,443 0 0 43,200 rio.public.tmp_drill_0320 1 1 0 181 0 0 5 rio.public.temp0000287757 1 0 0 1,383 0 48 80 rio.public.temp0000287803 1 0 0 2,068 0 18 46 rio.public.temp0000287753 16 0 0 117,345 0 409 7,847 rio.public.temp0000287839 3 0 0 72,464 0 0 5,184 brasilia.public.temp0000237766 3 0 0 9,569 0 51 717 rio.public.temp0000287819 1 0 0 1,656 0 36 92 rio.public.temp0000287829 1 0 0 1,656 0 36 92 rio.public.temp0000287651 4 0 0 51,010 0 96 3,616 rio.public.temp0000287771 30 0 0 474,793 0 488 33,752 brasilia.public.temp0000237756 4 0 0 12,756 0 68 956 contagem.public.temp0000226794 16 0 0 20,952 0 437 1,611 rio.public.temp0000287785 11 0 0 35,385 0 356 796 rio.public.temp0000287749 2 0 0 25,505 0 48 1,808 brasilia.public.temp0000237786 2 0 0 6,384 0 33 479 rio.public.temp0000287835 1 0 0 24,154 0 0 1,728 rio.public.temp0000287827 4 0 0 8,818 0 149 363 rio.public.temp0000287781 1 0 0 1,383 0 48 80 brasilia.public.temp0000237730 2 0 0 6,376 0 34 478 Total 500 249 446,828 15,383,987 186,306 5,543 614,978 Pages removed per table
Key values
- pg_catalog.pg_attribute (726) Main table with removed pages on database brasilia
- 5543 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed brasilia.pg_catalog.pg_attribute 22 22 141061 726 rio.public.temp0000287771 30 0 0 488 rio.public.temp0000287312 16 0 0 440 contagem.public.temp0000226794 16 0 0 437 rio.public.temp0000287753 16 0 0 409 rio.public.temp0000287785 11 0 0 356 rio.pg_catalog.pg_attribute 42 29 127623 275 rio.public.temp0000287821 6 0 0 259 rio.public.temp0000287306 7 0 0 247 brasilia.pg_catalog.pg_class 16 16 9322 197 brasilia.public.temp0000237748 11 0 0 187 rio.public.temp0000287827 4 0 0 149 rio.public.temp0000287388 6 0 0 147 rio.public.temp0000287811 7 0 0 126 contagem.pg_catalog.pg_attribute 16 16 84780 110 rio.public.temp0000287651 4 0 0 96 contagem.pg_catalog.pg_class 14 14 789 76 brasilia.pg_catalog.pg_type 14 14 7006 75 brasilia.public.temp0000237756 4 0 0 68 rio.pg_catalog.pg_class 38 21 3686 53 brasilia.public.temp0000237766 3 0 0 51 rio.public.temp0000287769 1 0 0 48 rio.public.temp0000287755 1 0 0 48 rio.public.temp0000287757 1 0 0 48 rio.public.temp0000287749 2 0 0 48 rio.public.temp0000287781 1 0 0 48 rio.public.temp0000287787 1 0 0 46 rio.public.temp0000287819 1 0 0 36 rio.public.temp0000287829 1 0 0 36 brasilia.public.temp0000237730 2 0 0 34 brasilia.public.temp0000237786 2 0 0 33 brasilia.pg_catalog.pg_depend 6 6 2957 31 contagem.pg_catalog.pg_type 11 11 5812 27 rio.public.temp0000287803 1 0 0 18 brasilia.public.temp0000237704 1 0 0 17 brasilia.pg_catalog.pg_index 7 7 4301 15 contagem.pg_catalog.pg_depend 8 8 3603 14 rio.pg_catalog.pg_index 14 13 3044 10 rio.pg_catalog.pg_type 26 15 4864 9 contagem.pg_catalog.pg_index 8 8 2860 5 rio.public.temp0000287795 3 0 0 0 rio.pg_catalog.pg_statistic 5 5 9797 0 contagem.pg_toast.pg_toast_2619 1 1 140 0 rio.public.usuarios 5 5 321 0 rio.auditor.auditor_2026_08 1 0 120 0 rio.public.giga_testes 1 1 1382 0 contagem.auditor.auditor_2026_08 2 0 0 0 brasilia.pg_catalog.pg_statistic 4 4 6730 0 contagem.public.nf_entrada 2 2 826 0 brasilia.auditor.auditor_2026_08 1 0 155 0 rio.public.temp0000287783 25 0 0 0 rio.public.tmp_drill_0302 7 2 795 0 rio.public.tmp_drill_0320 1 1 0 0 template1.pg_catalog.pg_shdepend 2 2 1622 0 contagem.public.usuarios 11 0 653 0 contagem.pg_catalog.pg_statistic 2 2 5478 0 rio.pg_toast.pg_toast_2619 3 3 1019 0 rio.public.temp0000287839 3 0 0 0 postgres.pg_catalog.pg_shdepend 3 3 2983 0 brasilia.pg_toast.pg_toast_2619 3 3 312 0 brasilia.pg_catalog.pg_shdepend 5 5 4601 0 brasilia.public.nf_entrada 2 2 1081 0 rio.public.temp0000287835 1 0 0 0 rio.pg_catalog.pg_depend 9 8 7105 0 Total 500 249 446,828 5,543 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Aug 07 00 1 1 01 0 4 02 0 0 03 0 2 04 0 3 05 6 4 06 2 4 07 38 65 08 92 112 09 75 122 10 66 100 11 23 79 12 6 14 13 45 99 14 46 105 15 44 89 16 6 47 17 22 51 18 26 44 19 0 0 20 0 0 21 2 0 22 0 0 23 0 3 - 19.11 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- ShareLock Main Lock Type
- 4 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 2 2m29s 54s989ms 1m34s 1m14s call rs_giga_triagem (?);-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-07 10:36:46 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-07 10:06:09 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-07 00:05:38 Database: rio User: intelifix Remote: [local] Application: psql
2 1 2s471ms 2s471ms 2s471ms 2s471ms select * from rs_lote_manutencao (?);-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"2", "cliente" :"1", "modelo" :"129", "usuario" :"407", "tipo" :"N", "itens" :"007", "nota-fiscal" :"11220", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}');
Date: 2026-08-07 15:34:44 Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"2", "cliente" :"1", "modelo" :"42", "usuario" :"413", "tipo" :"N", "itens" :"09", "nota-fiscal" :"11220", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}');
Date: 2026-08-07 13:14:58 Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"7", "cliente" :"11", "modelo" :"298", "usuario" :"428", "tipo" :"N", "itens" :"01", "nota-fiscal" :"2022", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}');
Date: 2026-08-07 11:48:33 Database: brasilia User: intelifix Remote: [local] Application: [unknown]
3 1 1s9ms 1s9ms 1s9ms 1s9ms drop table if exists temp0000287771;-
DROP TABLE IF EXISTS temp0000287771;
Date: 2026-08-07 11:37:33 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
DROP TABLE IF EXISTS temp0000287771;
Date: 2026-08-07 11:37:33 Database: rio User: intelifix Remote: [local] Application: [unknown]
Queries that waited the most
Rank Wait time Query 1 1m34s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-08-07 10:36:45 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 54s989ms CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-08-07 10:06:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 2s471ms SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"2", "cliente" :"1", "modelo" :"129", "usuario" :"407", "tipo" :"N", "itens" :"007", "nota-fiscal" :"11220", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}');[ Date: 2026-08-07 15:34:44 - Database: contagem - User: intelifix - Remote: [local] - Application: [unknown] ]
4 1s9ms DROP TABLE IF EXISTS temp0000287771;[ Date: 2026-08-07 11:37:33 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
-
Queries
Queries by type
Key values
- 3,959 Total read queries
- 1,300 Total write queries
Queries by database
Key values
- rio Main database
- 2,999 Requests
- 5h31m9s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 5,657 Requests
User Request type Count Duration etiquetas Total 23 4s870ms select 23 4s870ms intelifix Total 5,657 7h47m21s copy to 413 48m3s ddl 887 44m50s others 525 47m52s select 3,832 5h26m35s lenon Total 104 1m5s select 104 1m5s Duration by user
Key values
- 7h47m21s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 23 4s870ms select 23 4s870ms intelifix Total 5,657 7h47m21s copy to 413 48m3s ddl 887 44m50s others 525 47m52s select 3,832 5h26m35s lenon Total 104 1m5s select 104 1m5s Queries by host
Key values
- [local] Main host
- 5,784 Requests
- 7h48m31s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 4,609 Requests
- 4h34m54s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-08-07 13:46:07 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 2,942 100-500ms duration
Slowest individual queries
Rank Duration Query 1 10m20s analyze verbose;[ Date: 2026-08-07 05:10:22 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 10m15s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-07 11:15:16 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 9m48s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-07 08:14:49 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 9m26s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-07 07:14:27 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 9m12s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-07 09:14:14 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 9m5s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-07 12:14:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 8m53s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-07 15:13:54 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 8m28s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-07 20:13:29 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 8m22s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-07 10:13:23 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 7m42s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-07 14:12:43 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 7m7s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028193, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-07 11:46:57 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
12 6m45s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028150, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-07 07:35:44 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
13 6m24s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028190, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-07 10:36:45 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
14 6m13s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-07 17:11:15 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 6m12s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028161, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-07 08:57:42 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
16 6m11s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-07 16:11:13 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 6m9s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-07 13:11:10 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 6m4s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-07 21:11:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 5m59s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028170, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-07 09:41:17 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
20 5m56s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028157, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-07 08:20:08 - 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 2h11m15s 48 1s355ms 10m15s 2m44s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 07 07 3 10m14s 3m24s 08 3 10m37s 3m32s 09 3 9m59s 3m19s 10 3 9m6s 3m2s 11 3 10m56s 3m38s 12 3 9m38s 3m12s 13 3 6m29s 2m9s 14 3 8m13s 2m44s 15 3 9m21s 3m7s 16 3 6m34s 2m11s 17 3 6m32s 2m10s 18 3 6m4s 2m1s 19 3 5m54s 1m58s 20 3 8m56s 2m58s 21 3 6m22s 2m7s 22 3 6m10s 2m3s [ User: intelifix - Total duration: 2h11m15s - Times executed: 48 ]
[ Application: psql - Total duration: 2h11m15s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-07 11:15:16 Duration: 10m15s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-07 08:14:49 Duration: 9m48s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-07 07:14:27 Duration: 9m26s Database: rio User: intelifix Remote: [local] Application: psql
2 1h27m13s 47 223ms 5m32s 1m51s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 07 07 3 6m 2m 08 3 6m56s 2m18s 09 3 6m43s 2m14s 10 3 6m19s 2m6s 11 3 7m13s 2m24s 12 3 6m21s 2m7s 13 3 4m27s 1m29s 14 2 6m38s 3m19s 15 3 5m55s 1m58s 16 3 4m43s 1m34s 17 3 4m40s 1m33s 18 3 4m1s 1m20s 19 3 3m57s 1m19s 20 3 5m41s 1m53s 21 3 3m51s 1m17s 22 3 3m42s 1m14s [ User: intelifix - Total duration: 1h27m13s - Times executed: 47 ]
[ Application: psql - Total duration: 1h27m13s - Times executed: 47 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-07 11:23:03 Duration: 5m32s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-07 08:22:25 Duration: 5m28s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-07 14:19:47 Duration: 5m23s Database: brasilia User: intelifix Remote: [local] Application: psql
3 1h3m4s 199 153ms 7m7s 19s17ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 07 06 3 1s581ms 527ms 07 13 8m1s 37s13ms 08 27 18m9s 40s358ms 09 27 8m9s 18s137ms 10 43 12m40s 17s691ms 11 19 7m42s 24s344ms 12 2 765ms 382ms 13 16 1m1s 3s823ms 14 13 1m1s 4s725ms 15 17 5m11s 18s308ms 16 2 1s175ms 587ms 17 9 23s724ms 2s636ms 18 8 39s530ms 4s941ms [ User: intelifix - Total duration: 1h3m4s - Times executed: 199 ]
[ Application: [unknown] - Total duration: 1h3m4s - Times executed: 199 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028193, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-07 11:46:57 Duration: 7m7s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028150, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-07 07:35:44 Duration: 6m45s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028190, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-07 10:36:45 Duration: 6m24s Database: rio User: intelifix Remote: [local] Application: [unknown]
4 17m54s 3 2m41s 10m20s 5m58s analyze verbose;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 07 05 3 17m54s 5m58s [ User: intelifix - Total duration: 17m54s - Times executed: 3 ]
[ Application: psql - Total duration: 17m54s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-08-07 05:10:22 Duration: 10m20s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-08-07 05:15:14 Duration: 4m52s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-08-07 05:17:56 Duration: 2m41s Database: contagem User: intelifix Remote: [local] Application: psql
5 13m45s 276 230ms 1m39s 2s989ms call rs_giga_triagem (?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Aug 07 00 12 35s729ms 2s977ms 01 12 23s864ms 1s988ms 02 12 24s954ms 2s79ms 03 12 28s983ms 2s415ms 04 12 25s404ms 2s117ms 05 12 25s357ms 2s113ms 06 12 24s855ms 2s71ms 07 12 27s782ms 2s315ms 08 12 35s570ms 2s964ms 09 12 29s560ms 2s463ms 10 12 3m8s 15s682ms 11 12 38s582ms 3s215ms 12 12 27s837ms 2s319ms 13 12 30s683ms 2s556ms 14 12 32s762ms 2s730ms 15 12 30s946ms 2s578ms 16 12 27s514ms 2s292ms 17 12 28s375ms 2s364ms 18 12 26s134ms 2s177ms 19 12 26s954ms 2s246ms 20 12 35s367ms 2s947ms 21 12 24s588ms 2s49ms 22 12 25s74ms 2s89ms [ User: intelifix - Total duration: 13m45s - Times executed: 276 ]
[ Application: psql - Total duration: 13m45s - Times executed: 276 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-07 10:36:46 Duration: 1m39s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-07 10:06:09 Duration: 1m Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-07 00:05:38 Duration: 13s894ms Database: rio User: intelifix Remote: [local] Application: psql
6 12m2s 55 10s232ms 54s717ms 13s144ms create table temp0000287771 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 07 07 12 2m18s 11s583ms 08 11 2m15s 12s292ms 09 13 2m44s 12s625ms 10 13 2m40s 12s334ms 11 6 2m4s 20s707ms [ User: intelifix - Total duration: 12m2s - Times executed: 55 ]
[ Application: [unknown] - Total duration: 12m2s - Times executed: 55 ]
-
CREATE TABLE temp0000287771 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-07 11:37:06 Duration: 54s717ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287771 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-07 11:39:23 Duration: 16s771ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287771 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-07 09:33:15 Duration: 15s97ms Database: rio User: intelifix Remote: [local] Application: [unknown]
7 10m8s 735 150ms 4s916ms 827ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 07 07 37 25s423ms 687ms 08 141 1m28s 629ms 09 132 1m28s 673ms 10 96 1m11s 746ms 11 70 1m1s 882ms 12 49 43s213ms 881ms 13 37 43s366ms 1s172ms 14 74 1m28s 1s193ms 15 46 52s573ms 1s142ms 16 29 25s881ms 892ms 17 24 18s522ms 771ms [ User: intelifix - Total duration: 10m8s - Times executed: 735 ]
[ Application: [unknown] - Total duration: 10m8s - Times executed: 735 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (51823, 407, '834241935001415,241621459899,241631250419,241689194053,241727039092,241668288702,241668286883,241607291829,241710354154,241695648903,241664878403,241647341933,241665231726,241636081025,241671549615,241703714359,241656707784,241708948393,241689131623,241619346383,241637701430,241629854861,241680307697,230048398594,241717134344,241636110220,241661099100,241726982141,241646434055,241673360320', '',0321,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-07 14:12:35 Duration: 4s916ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (51906, 413, '835237935003807,241708857172,241637701329,241620818288,241675909513,241617420517,241731214248,241680371520,241604736977,241659797491,241663802125,241654614954,241614514363,241680371116,241731020414,241659806987,241714062743,241649802734,241622507791,241678327885,241636021524,241680344143,241614493654,241594129904,241654454860,241654459709,241704684970,241680340810,241614476884,241663104851,241656770620', '',0321,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-07 15:05:04 Duration: 4s661ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (275575, 450, '14011885850079203303,C85D385BB78F,C85D38884B4A,C85D38DCC392,C85D38F4017C,8C444FC140EE,C85D381478A5,C85D38793DCA,D86C5A00E6BC,C85D386EEFBF,C85D38105C1A,8C444FD61B1B,C85D380961F4,C85D38D71DE7,8C444FE9F791,C85D38A334EA,D86C5A3C2391,8C444FEBD79D,C85D38877713,C85D38F298A1,C85D38A13FC9,C85D386C3E9A,8C444FD93237,C85D380978EC,D86C5A015D45,C85D387BD6BC,,C85D3892B3FE,C85D380AF2D7,C85D38DCC464,C85D380D65F8,C85D38E4FF19,8C444FE08351,C85D38DCEE8E,C85D385AC567,C85D380E517B', '',0151,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-07 12:15:41 Duration: 3s918ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 9m41s 946 150ms 9s849ms 614ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Aug 07 06 1 1s352ms 1s352ms 07 146 1m45s 720ms 08 160 1m47s 670ms 09 102 58s519ms 573ms 10 87 57s770ms 664ms 11 182 1m41s 555ms 12 12 8s380ms 698ms 13 130 1m17s 595ms 14 36 17s684ms 491ms 15 46 22s507ms 489ms 16 31 16s979ms 547ms 17 13 6s943ms 534ms [ User: intelifix - Total duration: 9m41s - Times executed: 946 ]
[ Application: [unknown] - Total duration: 9m41s - Times executed: 946 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "243112", "modelo" : "287", "itens" : "229954600115,230004952234,229995172626,229960077180,229997547784,229958241828,229921131012,229961382224,229965161224,229961413237,229993124850,229994759195,229970160814,229994567886,229997526671,229995722938,229992550822,230017167488,229938098403,229937944448", "usuario" : "414", "caixa" : "2912261", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-07 07:24:22 Duration: 9s849ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "275217", "modelo" : "141", "itens" : "229738110917,229884698095,229884320910,229663294748,229932958495,229740288098,229736602240,229884525980,229750374661,229741026262,229662039912,229860886467,229817142042,216932369600,216940466372,229740791616,216945262531,229782273038,229779255560,229933591824,229812187786,229781129705,229665023043,229690827592,229660501435,229780572749,229743129497,229689179003", "usuario" : "414", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "246547321535,226301794766,246165870110,246512400809,246340130102,246524003142,246529959806,246437745666,246245776280,246526994960,246488052024,246649006486,246630851314,246433457088,246474646585,246531100715,246456550106,246596669099,246559515575,246104638992,246461304868,246587289408,246467396573,246516352328,246423768095,246586804759,246546909091,246516047696,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-07 10:31:45 Duration: 2s872ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "274905", "modelo" : "141", "itens" : "229807520003,229741673251,229741640319,216945156684,229756118195,229741549298,229749726685,216943380810,229748059609,229686907490,229879499900,229671731835,229746140814,229808542235,229669095056,229687159816,229690505563,229751645862,229670359714,229740032440,229743426373,229780496579,229737738096,229753027781,229817128707,229669310409,229745749911,229805740716", "usuario" : "405", "caixa" : "3413885", "tecnico-cosmetico" : "299", "acessorios" : "246604990519,246526780215,246528242445,246461252944,246586338192,246570000213,246563321929,246471803749,246551382032,246513569597,246653280821,246495564059,246550074059,246618332236,246513641020,246517657797,246507042441,246532706774,246020080618,246569835572,246546137086,246583711416,246527598082,246529459195,246630914956,246514299804,246552200406,246596154751,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-07 08:42:16 Duration: 2s836ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 8m51s 40 10s317ms 56s556ms 13s288ms create table temp0000287783 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 07 08 12 3m7s 15s642ms 09 17 3m29s 12s325ms 10 11 2m14s 12s209ms [ User: intelifix - Total duration: 8m51s - Times executed: 40 ]
[ Application: [unknown] - Total duration: 8m51s - Times executed: 40 ]
-
CREATE TABLE temp0000287783 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-07 08:46:49 Duration: 56s556ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287783 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-07 09:18:47 Duration: 16s305ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287783 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-07 09:31:19 Duration: 14s127ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 7m22s 146 207ms 22s905ms 3s28ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 07 00 6 33s630ms 5s605ms 01 6 12s4ms 2s 02 5 12s754ms 2s550ms 03 6 18s170ms 3s28ms 04 6 15s715ms 2s619ms 05 5 17s476ms 3s495ms 07 10 31s83ms 3s108ms 08 12 57s187ms 4s765ms 09 12 50s368ms 4s197ms 10 12 49s373ms 4s114ms 11 12 34s191ms 2s849ms 12 12 23s221ms 1s935ms 13 11 28s179ms 2s561ms 14 6 11s258ms 1s876ms 15 6 11s74ms 1s845ms 16 6 5s57ms 842ms 17 3 2s403ms 801ms 21 4 15s880ms 3s970ms 22 6 13s186ms 2s197ms [ User: intelifix - Total duration: 7m22s - Times executed: 146 ]
[ Application: psql - Total duration: 7m22s - Times executed: 146 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-07 00:05:24 Duration: 22s905ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-07 07:35:12 Duration: 10s610ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-07 08:55:11 Duration: 10s288ms Database: rio User: intelifix Remote: [local] Application: psql
11 6m15s 58 1s790ms 18s179ms 6s468ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 07 07 4 34s441ms 8s610ms 08 5 46s38ms 9s207ms 09 1 9s401ms 9s401ms 10 9 1m13s 8s222ms 11 4 54s774ms 13s693ms 12 1 4s746ms 4s746ms 13 4 37s57ms 9s264ms 14 7 55s67ms 7s866ms 15 6 15s144ms 2s524ms 16 8 20s141ms 2s517ms 17 9 24s377ms 2s708ms [ User: intelifix - Total duration: 6m15s - Times executed: 58 ]
[ Application: [unknown] - Total duration: 6m15s - Times executed: 58 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-07', 0302, '', '', 0, 6, '2026-08-07');
Date: 2026-08-07 07:46:44 Duration: 18s179ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-07', 0175, '', '', 0, 6, '2026-08-01');
Date: 2026-08-07 13:44:58 Duration: 18s137ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-07', 0302, '', '', 0, 6, '2026-08-07');
Date: 2026-08-07 10:23:30 Duration: 17s56ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 3m56s 680 150ms 1s533ms 347ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 07 13 125 41s867ms 334ms 14 330 1m39s 300ms 15 127 1m 476ms 16 72 25s23ms 347ms 17 26 9s932ms 382ms [ User: intelifix - Total duration: 3m56s - Times executed: 680 ]
[ Application: [unknown] - Total duration: 3m56s - Times executed: 680 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"51323","seriais":"229690211921,229866089007,229690854565,216944803440,229662942638,229811300215,229670488289,229805223437,229808947481,229685284762,229669699111,229813786068,229808843656,229747733640,229728456977,229934150723,229810604557,216944305860,229781785459,229782439192,229733715762,216940420409,216936655877,229807413449,229781832838,229669200825,229690868203,229781830919,216944595159,229837120120,229933515778,229808084962,229810947474,229816608701,229749232945,216939545362,229879716161,229740188593,229782716874,229738239717,229778939817,229660299191,229737081434,229807404963,229668723348,229751500215,229782330822,229934078997,229805501119,216938846169","usuario":"419","observacao":""}');
Date: 2026-08-07 15:46:23 Duration: 1s533ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"51812","seriais":"241659859797,241604720815,241711201117,241659640204,241597401627,241727009012,241727510711,241728703543,241698688504,241636066275,241604800015,241654478599,241713741926,230043629510,241671557090,241617427789,241647992030,241676709703,241592186987,230043581324,241711187478,241646283838,241664755259,241671556080,241783849901,241628182734,241664841329,241732105255,241595004041,241645524359,241695561319,241669220219,241593454754,241678322936,241607827694,241668279509,241671567900,241659680915,241614498705,241602690314,241599310523,241659770520,241713704952,241713707275,241663120308,241702249906,241673329104,241646413447,241678301924,241592091322","usuario":"416","observacao":""}');
Date: 2026-08-07 15:08:28 Duration: 1s310ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"51323","seriais":"229669947698,229805239802,216940589415,229816217495,216944396778,229865996573,229934063744,229685445664,229933293759,229753801326,229837169797,229859791726,229787199411,229748610202,229747563242,229865270712,216943421824,229933344347,229806783758,229739804965,229925598899,229865768492,229850143747,229866009302,229809318607,229812660213,216936627490,229925328693,229751102140,229860353251,229686723556,229805260209,229737730622,229740314465,229782951522,216932032340,229670192526,229744075359,229670211316","usuario":"419","observacao":""}');
Date: 2026-08-07 15:47:37 Duration: 1s289ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
13 3m19s 57 2s923ms 5s102ms 3s500ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Aug 07 08 5 18s596ms 3s719ms 09 4 12s660ms 3s165ms 10 4 14s450ms 3s612ms 11 4 15s576ms 3s894ms 12 4 12s989ms 3s247ms 13 4 13s706ms 3s426ms 14 4 12s653ms 3s163ms 15 3 9s376ms 3s125ms 16 3 9s538ms 3s179ms 17 3 11s390ms 3s796ms 18 3 11s456ms 3s818ms 19 5 17s47ms 3s409ms 20 4 13s561ms 3s390ms 21 3 9s965ms 3s321ms 22 4 16s537ms 4s134ms [ User: intelifix - Total duration: 3m19s - Times executed: 57 ]
[ Application: psql - Total duration: 3m19s - Times executed: 57 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-07 22:20:10 Duration: 5s102ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-07 18:20:10 Duration: 4s406ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-07 11:20:09 Duration: 4s346ms Database: brasilia User: intelifix Remote: [local] Application: psql
14 3m9s 4 4s802ms 1m30s 47s318ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 07 20 2 1m35s 47s893ms 23 2 1m33s 46s743ms [ User: intelifix - Total duration: 3m9s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m9s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-07 20:08:50 Duration: 1m30s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-07 23:16:43 Duration: 1m27s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-07 23:36:35 Duration: 5s701ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
15 3m 25 1s787ms 25s79ms 7s238ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 07 09 2 8s220ms 4s110ms 10 2 11s274ms 5s637ms 11 1 3s227ms 3s227ms 13 3 38s16ms 12s672ms 14 4 16s430ms 4s107ms 15 3 24s990ms 8s330ms 17 3 29s567ms 9s855ms 18 7 49s228ms 7s32ms [ User: intelifix - Total duration: 3m - Times executed: 25 ]
[ Application: psql - Total duration: 3m - Times executed: 25 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 398); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (04498);
Date: 2026-08-07 13:49:45 Duration: 25s79ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 420); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01623);
Date: 2026-08-07 17:18:18 Duration: 15s102ms Database: contagem User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 420); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01621);
Date: 2026-08-07 15:50:21 Duration: 13s147ms Database: contagem User: intelifix Remote: [local] Application: psql
16 2m35s 13 9s911ms 14s840ms 11s948ms create table temp0000287753 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Aug 07 09 13 2m35s 11s948ms [ User: intelifix - Total duration: 2m35s - Times executed: 13 ]
[ Application: [unknown] - Total duration: 2m35s - Times executed: 13 ]
-
CREATE TABLE temp0000287753 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-07 09:42:02 Duration: 14s840ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287753 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-07 09:54:19 Duration: 12s846ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287753 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-07 09:57:34 Duration: 12s822ms Database: rio User: intelifix Remote: [local] Application: [unknown]
17 2m31s 41 150ms 24s92ms 3s691ms select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Aug 07 07 2 25s605ms 12s802ms 08 7 32s715ms 4s673ms 09 10 30s348ms 3s34ms 10 7 21s535ms 3s76ms 11 1 14s488ms 14s488ms 13 1 189ms 189ms 14 3 18s765ms 6s255ms 15 3 1s814ms 604ms 17 2 3s249ms 1s624ms 18 5 2s638ms 527ms [ User: intelifix - Total duration: 2m31s - Times executed: 41 ]
[ Application: psql - Total duration: 2m31s - Times executed: 41 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028161);
Date: 2026-08-07 08:51:19 Duration: 24s92ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028150);
Date: 2026-08-07 07:28:48 Duration: 19s653ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 184); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028194);
Date: 2026-08-07 14:02:26 Duration: 15s449ms Database: rio User: intelifix Remote: [local] Application: psql
18 2m23s 46 200ms 35s256ms 3s122ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 07 07 4 2s985ms 746ms 08 11 26s181ms 2s380ms 09 17 56s792ms 3s340ms 10 10 54s921ms 5s492ms 11 2 1s310ms 655ms 14 1 300ms 300ms 15 1 1s145ms 1s145ms [ User: intelifix - Total duration: 2m23s - Times executed: 46 ]
[ Application: psql - Total duration: 2m23s - Times executed: 46 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028166);
Date: 2026-08-07 09:19:05 Duration: 35s256ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028187);
Date: 2026-08-07 10:25:25 Duration: 22s953ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028184);
Date: 2026-08-07 10:09:29 Duration: 19s165ms Database: rio User: intelifix Remote: [local] Application: psql
19 1m56s 33 2s961ms 5s887ms 3s519ms call rs_tcia_processa_lotes () / 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 #19
Day Hour Count Duration Avg duration Aug 07 08 1 3s224ms 3s224ms 09 2 6s687ms 3s343ms 10 2 7s147ms 3s573ms 11 2 6s916ms 3s458ms 12 2 6s850ms 3s425ms 13 2 7s230ms 3s615ms 14 2 6s722ms 3s361ms 15 3 9s743ms 3s247ms 16 3 10s136ms 3s378ms 17 3 9s753ms 3s251ms 18 3 13s86ms 4s362ms 19 1 3s977ms 3s977ms 20 2 6s533ms 3s266ms 21 3 11s915ms 3s971ms 22 2 6s229ms 3s114ms [ User: intelifix - Total duration: 1m56s - Times executed: 33 ]
[ Application: psql - Total duration: 1m56s - Times executed: 33 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: 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-08-07 18:00:07 Duration: 5s887ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: 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-08-07 21:20:05 Duration: 4s615ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: 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-08-07 21:40:05 Duration: 4s230ms Database: rio User: intelifix Remote: [local] Application: psql
20 1m55s 6 10s188ms 54s297ms 19s182ms create table temp0000287651 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 07 07 6 1m55s 19s182ms [ User: intelifix - Total duration: 1m55s - Times executed: 6 ]
[ Application: [unknown] - Total duration: 1m55s - Times executed: 6 ]
-
CREATE TABLE temp0000287651 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-07 07:02:25 Duration: 54s297ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287651 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-07 07:02:39 Duration: 13s685ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287651 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-07 07:05:40 Duration: 12s527ms Database: rio User: intelifix Remote: [local] Application: [unknown]
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 946 9m41s 150ms 9s849ms 614ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 07 06 1 1s352ms 1s352ms 07 146 1m45s 720ms 08 160 1m47s 670ms 09 102 58s519ms 573ms 10 87 57s770ms 664ms 11 182 1m41s 555ms 12 12 8s380ms 698ms 13 130 1m17s 595ms 14 36 17s684ms 491ms 15 46 22s507ms 489ms 16 31 16s979ms 547ms 17 13 6s943ms 534ms [ User: intelifix - Total duration: 9m41s - Times executed: 946 ]
[ Application: [unknown] - Total duration: 9m41s - Times executed: 946 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "243112", "modelo" : "287", "itens" : "229954600115,230004952234,229995172626,229960077180,229997547784,229958241828,229921131012,229961382224,229965161224,229961413237,229993124850,229994759195,229970160814,229994567886,229997526671,229995722938,229992550822,230017167488,229938098403,229937944448", "usuario" : "414", "caixa" : "2912261", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-07 07:24:22 Duration: 9s849ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "275217", "modelo" : "141", "itens" : "229738110917,229884698095,229884320910,229663294748,229932958495,229740288098,229736602240,229884525980,229750374661,229741026262,229662039912,229860886467,229817142042,216932369600,216940466372,229740791616,216945262531,229782273038,229779255560,229933591824,229812187786,229781129705,229665023043,229690827592,229660501435,229780572749,229743129497,229689179003", "usuario" : "414", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "246547321535,226301794766,246165870110,246512400809,246340130102,246524003142,246529959806,246437745666,246245776280,246526994960,246488052024,246649006486,246630851314,246433457088,246474646585,246531100715,246456550106,246596669099,246559515575,246104638992,246461304868,246587289408,246467396573,246516352328,246423768095,246586804759,246546909091,246516047696,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-07 10:31:45 Duration: 2s872ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "274905", "modelo" : "141", "itens" : "229807520003,229741673251,229741640319,216945156684,229756118195,229741549298,229749726685,216943380810,229748059609,229686907490,229879499900,229671731835,229746140814,229808542235,229669095056,229687159816,229690505563,229751645862,229670359714,229740032440,229743426373,229780496579,229737738096,229753027781,229817128707,229669310409,229745749911,229805740716", "usuario" : "405", "caixa" : "3413885", "tecnico-cosmetico" : "299", "acessorios" : "246604990519,246526780215,246528242445,246461252944,246586338192,246570000213,246563321929,246471803749,246551382032,246513569597,246653280821,246495564059,246550074059,246618332236,246513641020,246517657797,246507042441,246532706774,246020080618,246569835572,246546137086,246583711416,246527598082,246529459195,246630914956,246514299804,246552200406,246596154751,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-07 08:42:16 Duration: 2s836ms Database: rio User: intelifix Remote: [local] Application: [unknown]
2 735 10m8s 150ms 4s916ms 827ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 07 07 37 25s423ms 687ms 08 141 1m28s 629ms 09 132 1m28s 673ms 10 96 1m11s 746ms 11 70 1m1s 882ms 12 49 43s213ms 881ms 13 37 43s366ms 1s172ms 14 74 1m28s 1s193ms 15 46 52s573ms 1s142ms 16 29 25s881ms 892ms 17 24 18s522ms 771ms [ User: intelifix - Total duration: 10m8s - Times executed: 735 ]
[ Application: [unknown] - Total duration: 10m8s - Times executed: 735 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (51823, 407, '834241935001415,241621459899,241631250419,241689194053,241727039092,241668288702,241668286883,241607291829,241710354154,241695648903,241664878403,241647341933,241665231726,241636081025,241671549615,241703714359,241656707784,241708948393,241689131623,241619346383,241637701430,241629854861,241680307697,230048398594,241717134344,241636110220,241661099100,241726982141,241646434055,241673360320', '',0321,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-07 14:12:35 Duration: 4s916ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (51906, 413, '835237935003807,241708857172,241637701329,241620818288,241675909513,241617420517,241731214248,241680371520,241604736977,241659797491,241663802125,241654614954,241614514363,241680371116,241731020414,241659806987,241714062743,241649802734,241622507791,241678327885,241636021524,241680344143,241614493654,241594129904,241654454860,241654459709,241704684970,241680340810,241614476884,241663104851,241656770620', '',0321,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-07 15:05:04 Duration: 4s661ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (275575, 450, '14011885850079203303,C85D385BB78F,C85D38884B4A,C85D38DCC392,C85D38F4017C,8C444FC140EE,C85D381478A5,C85D38793DCA,D86C5A00E6BC,C85D386EEFBF,C85D38105C1A,8C444FD61B1B,C85D380961F4,C85D38D71DE7,8C444FE9F791,C85D38A334EA,D86C5A3C2391,8C444FEBD79D,C85D38877713,C85D38F298A1,C85D38A13FC9,C85D386C3E9A,8C444FD93237,C85D380978EC,D86C5A015D45,C85D387BD6BC,,C85D3892B3FE,C85D380AF2D7,C85D38DCC464,C85D380D65F8,C85D38E4FF19,8C444FE08351,C85D38DCEE8E,C85D385AC567,C85D380E517B', '',0151,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-07 12:15:41 Duration: 3s918ms Database: rio User: intelifix Remote: [local] Application: [unknown]
3 680 3m56s 150ms 1s533ms 347ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 07 13 125 41s867ms 334ms 14 330 1m39s 300ms 15 127 1m 476ms 16 72 25s23ms 347ms 17 26 9s932ms 382ms [ User: intelifix - Total duration: 3m56s - Times executed: 680 ]
[ Application: [unknown] - Total duration: 3m56s - Times executed: 680 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"51323","seriais":"229690211921,229866089007,229690854565,216944803440,229662942638,229811300215,229670488289,229805223437,229808947481,229685284762,229669699111,229813786068,229808843656,229747733640,229728456977,229934150723,229810604557,216944305860,229781785459,229782439192,229733715762,216940420409,216936655877,229807413449,229781832838,229669200825,229690868203,229781830919,216944595159,229837120120,229933515778,229808084962,229810947474,229816608701,229749232945,216939545362,229879716161,229740188593,229782716874,229738239717,229778939817,229660299191,229737081434,229807404963,229668723348,229751500215,229782330822,229934078997,229805501119,216938846169","usuario":"419","observacao":""}');
Date: 2026-08-07 15:46:23 Duration: 1s533ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"51812","seriais":"241659859797,241604720815,241711201117,241659640204,241597401627,241727009012,241727510711,241728703543,241698688504,241636066275,241604800015,241654478599,241713741926,230043629510,241671557090,241617427789,241647992030,241676709703,241592186987,230043581324,241711187478,241646283838,241664755259,241671556080,241783849901,241628182734,241664841329,241732105255,241595004041,241645524359,241695561319,241669220219,241593454754,241678322936,241607827694,241668279509,241671567900,241659680915,241614498705,241602690314,241599310523,241659770520,241713704952,241713707275,241663120308,241702249906,241673329104,241646413447,241678301924,241592091322","usuario":"416","observacao":""}');
Date: 2026-08-07 15:08:28 Duration: 1s310ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"51323","seriais":"229669947698,229805239802,216940589415,229816217495,216944396778,229865996573,229934063744,229685445664,229933293759,229753801326,229837169797,229859791726,229787199411,229748610202,229747563242,229865270712,216943421824,229933344347,229806783758,229739804965,229925598899,229865768492,229850143747,229866009302,229809318607,229812660213,216936627490,229925328693,229751102140,229860353251,229686723556,229805260209,229737730622,229740314465,229782951522,216932032340,229670192526,229744075359,229670211316","usuario":"419","observacao":""}');
Date: 2026-08-07 15:47:37 Duration: 1s289ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
4 276 13m45s 230ms 1m39s 2s989ms call rs_giga_triagem (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 07 00 12 35s729ms 2s977ms 01 12 23s864ms 1s988ms 02 12 24s954ms 2s79ms 03 12 28s983ms 2s415ms 04 12 25s404ms 2s117ms 05 12 25s357ms 2s113ms 06 12 24s855ms 2s71ms 07 12 27s782ms 2s315ms 08 12 35s570ms 2s964ms 09 12 29s560ms 2s463ms 10 12 3m8s 15s682ms 11 12 38s582ms 3s215ms 12 12 27s837ms 2s319ms 13 12 30s683ms 2s556ms 14 12 32s762ms 2s730ms 15 12 30s946ms 2s578ms 16 12 27s514ms 2s292ms 17 12 28s375ms 2s364ms 18 12 26s134ms 2s177ms 19 12 26s954ms 2s246ms 20 12 35s367ms 2s947ms 21 12 24s588ms 2s49ms 22 12 25s74ms 2s89ms [ User: intelifix - Total duration: 13m45s - Times executed: 276 ]
[ Application: psql - Total duration: 13m45s - Times executed: 276 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-07 10:36:46 Duration: 1m39s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-07 10:06:09 Duration: 1m Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-07 00:05:38 Duration: 13s894ms Database: rio User: intelifix Remote: [local] Application: psql
5 223 1m22s 154ms 811ms 368ms select * from rs_lotes_saida_lista (?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Aug 07 06 1 324ms 324ms 07 151 1m2s 411ms 08 56 15s213ms 271ms 13 14 4s219ms 301ms 15 1 192ms 192ms [ User: intelifix - Total duration: 1m22s - Times executed: 223 ]
[ Application: [unknown] - Total duration: 1m22s - Times executed: 223 ]
-
SELECT * FROM RS_LOTES_SAIDA_LISTA (103107);
Date: 2026-08-07 07:46:43 Duration: 811ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTES_SAIDA_LISTA (103107);
Date: 2026-08-07 07:46:38 Duration: 791ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTES_SAIDA_LISTA (103107);
Date: 2026-08-07 07:46:03 Duration: 736ms Database: rio User: intelifix Remote: [local] Application: [unknown]
6 199 1h3m4s 153ms 7m7s 19s17ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 07 06 3 1s581ms 527ms 07 13 8m1s 37s13ms 08 27 18m9s 40s358ms 09 27 8m9s 18s137ms 10 43 12m40s 17s691ms 11 19 7m42s 24s344ms 12 2 765ms 382ms 13 16 1m1s 3s823ms 14 13 1m1s 4s725ms 15 17 5m11s 18s308ms 16 2 1s175ms 587ms 17 9 23s724ms 2s636ms 18 8 39s530ms 4s941ms [ User: intelifix - Total duration: 1h3m4s - Times executed: 199 ]
[ Application: [unknown] - Total duration: 1h3m4s - Times executed: 199 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028193, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-07 11:46:57 Duration: 7m7s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028150, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-07 07:35:44 Duration: 6m45s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028190, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-07 10:36:45 Duration: 6m24s Database: rio User: intelifix Remote: [local] Application: [unknown]
7 146 7m22s 207ms 22s905ms 3s28ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 07 00 6 33s630ms 5s605ms 01 6 12s4ms 2s 02 5 12s754ms 2s550ms 03 6 18s170ms 3s28ms 04 6 15s715ms 2s619ms 05 5 17s476ms 3s495ms 07 10 31s83ms 3s108ms 08 12 57s187ms 4s765ms 09 12 50s368ms 4s197ms 10 12 49s373ms 4s114ms 11 12 34s191ms 2s849ms 12 12 23s221ms 1s935ms 13 11 28s179ms 2s561ms 14 6 11s258ms 1s876ms 15 6 11s74ms 1s845ms 16 6 5s57ms 842ms 17 3 2s403ms 801ms 21 4 15s880ms 3s970ms 22 6 13s186ms 2s197ms [ User: intelifix - Total duration: 7m22s - Times executed: 146 ]
[ Application: psql - Total duration: 7m22s - Times executed: 146 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-07 00:05:24 Duration: 22s905ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-07 07:35:12 Duration: 10s610ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-07 08:55:11 Duration: 10s288ms Database: rio User: intelifix Remote: [local] Application: psql
8 103 43s812ms 249ms 1s43ms 425ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Aug 07 07 7 2s812ms 401ms 08 12 6s71ms 505ms 09 21 8s286ms 394ms 10 15 6s513ms 434ms 11 9 3s684ms 409ms 12 4 1s994ms 498ms 13 6 2s984ms 497ms 14 5 1s864ms 372ms 15 11 4s907ms 446ms 16 2 716ms 358ms 17 4 1s399ms 349ms 18 7 2s575ms 367ms [ User: intelifix - Total duration: 43s812ms - Times executed: 103 ]
[ Application: [unknown] - Total duration: 43s812ms - Times executed: 103 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-08-07 08:46:13 Duration: 1s43ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-08-07 13:57:51 Duration: 761ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-08-07 10:55:03 Duration: 697ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
9 98 45s19ms 266ms 799ms 459ms select pro_id, pgp_sym_decrypt(nome, ?)::varchar, pgp_sym_decrypt(descricao, ?)::varchar, pgp_sym_decrypt(classe, ?)::varchar, pgp_sym_decrypt(php, ?)::varchar, pgp_sym_decrypt(extras, ?)::varchar from progs order by pro_id;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 07 00 1 442ms 442ms 01 2 783ms 391ms 02 1 354ms 354ms 03 1 371ms 371ms 04 1 422ms 422ms 05 2 770ms 385ms 06 3 1s225ms 408ms 07 9 3s557ms 395ms 08 10 4s750ms 475ms 09 12 5s949ms 495ms 10 9 4s56ms 450ms 11 7 3s462ms 494ms 12 3 1s459ms 486ms 13 11 5s529ms 502ms 14 4 2s132ms 533ms 15 8 3s630ms 453ms 16 4 1s583ms 395ms 17 5 2s526ms 505ms 18 1 360ms 360ms 21 3 1s223ms 407ms 23 1 427ms 427ms [ User: lenon - Total duration: 45s19ms - Times executed: 98 ]
[ Application: [unknown] - Total duration: 45s19ms - Times executed: 98 ]
-
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-08-07 09:30:14 Duration: 799ms Database: contagem User: lenon Remote: [local] Application: [unknown] Bind query: yes
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-08-07 11:00:11 Duration: 784ms Database: brasilia User: lenon Remote: [local] Application: [unknown] Bind query: yes
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-08-07 13:59:34 Duration: 780ms Database: contagem User: lenon Remote: [local] Application: [unknown] Bind query: yes
10 93 24s239ms 150ms 632ms 260ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 07 01 10 3s539ms 353ms 03 2 620ms 310ms 04 5 1s353ms 270ms 05 8 2s240ms 280ms 07 6 1s470ms 245ms 08 10 2s370ms 237ms 09 15 3s916ms 261ms 10 27 6s311ms 233ms 11 10 2s416ms 241ms [ User: intelifix - Total duration: 24s239ms - Times executed: 93 ]
[ Application: [unknown] - Total duration: 24s239ms - Times executed: 93 ]
-
SELECT * FROM RS_TRIAGEM (310, 5, '63', 2, '08A7C0694454,F8D2AC150954,D4E2CB907C04,08A7C07725BC,ECA81F1FC3DC,B85E71D74B28,F8D2AC1541E4,C4509CEEBCA4,F8D2AC4D0A80,D4E2CB8DA0AC,ECA81F1FB884,484BD4A78FAC,484BD4B434F4,484BD4ACE95C,B85E71C7D4E0,00CB7ADC4594,F8D2AC1661A0,80DAC2CD3FB0,B85E71C65B4C,3C82C08F52B8,E4BFFAF84D4C,B85E71DCFD98,08A7C04D013C,B85E71C3B554,F8D2AC166308,3C82C0917D68,ECA81F6B1014,B85E71E2F540,00CB7AE48740,B85E71EF2A04,C4509CF1C784,B85E71D96818,1C9D728358E4,F8D2AC14DBDC,1C9D726B8324,4075C3B805C8', NULL, NULL, 0185, 00);
Date: 2026-08-07 09:43:44 Duration: 632ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (428, 5, '73', 2, '229910662235,229876865165,229919080913,229919209511,229876226382,229894912325,229911297178,229871370724,229913447590,229871774960,229901812123,229870765860,229915132929,229901735572,229870739012,229895249507,229918060926,229908721316,229893787074', NULL, NULL, 0263, 00);
Date: 2026-08-07 01:21:33 Duration: 598ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (405, 5, '121', 2, '229740140004', NULL, NULL, 0141, 00);
Date: 2026-08-07 11:45:43 Duration: 533ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 90 52s204ms 322ms 925ms 580ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 07 00 1 795ms 795ms 01 2 924ms 462ms 03 1 515ms 515ms 04 1 574ms 574ms 05 2 928ms 464ms 06 2 1s41ms 520ms 07 7 3s868ms 552ms 08 10 5s741ms 574ms 09 12 7s141ms 595ms 10 9 5s13ms 557ms 11 6 3s805ms 634ms 12 3 1s857ms 619ms 13 11 6s588ms 598ms 14 4 2s537ms 634ms 15 8 4s600ms 575ms 16 4 2s131ms 532ms 17 5 2s982ms 596ms 18 1 515ms 515ms 23 1 640ms 640ms [ User: intelifix - Total duration: 52s204ms - Times executed: 90 ]
[ Application: [unknown] - Total duration: 52s204ms - Times executed: 90 ]
-
select * from rs_menu_grants (397, 18, 1);
Date: 2026-08-07 11:00:11 Duration: 925ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (80, 18, 1);
Date: 2026-08-07 09:30:14 Duration: 891ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (416, 21, 1);
Date: 2026-08-07 13:59:34 Duration: 856ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
12 77 25s698ms 152ms 774ms 333ms select (rs_fast_barras (b.eq_id)).* from caixa_itens a inner join fluxos b on b.flu_id = a.flu_id where a.cai_id = ? order by a.cai_ordem;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 07 07 14 4s647ms 331ms 08 19 7s805ms 410ms 09 3 1s157ms 385ms 10 4 1s771ms 442ms 11 5 947ms 189ms 12 1 398ms 398ms 13 8 2s235ms 279ms 14 7 1s681ms 240ms 15 8 1s866ms 233ms 16 5 1s796ms 359ms 17 3 1s389ms 463ms [ User: intelifix - Total duration: 25s698ms - Times executed: 77 ]
[ Application: [unknown] - Total duration: 25s698ms - Times executed: 77 ]
-
SELECT (RS_FAST_BARRAS (B.EQ_ID)).* FROM CAIXA_ITENS A INNER JOIN FLUXOS B ON B.FLU_ID = A.FLU_ID WHERE A.CAI_ID = 3413885 ORDER BY A.CAI_ORDEM;
Date: 2026-08-07 08:41:49 Duration: 774ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT (RS_FAST_BARRAS (B.EQ_ID)).* FROM CAIXA_ITENS A INNER JOIN FLUXOS B ON B.FLU_ID = A.FLU_ID WHERE A.CAI_ID = 126027 ORDER BY A.CAI_ORDEM;
Date: 2026-08-07 17:09:51 Duration: 761ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT (RS_FAST_BARRAS (B.EQ_ID)).* FROM CAIXA_ITENS A INNER JOIN FLUXOS B ON B.FLU_ID = A.FLU_ID WHERE A.CAI_ID = 3413863 ORDER BY A.CAI_ORDEM;
Date: 2026-08-07 08:42:54 Duration: 738ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 66 16s932ms 152ms 2s736ms 256ms select * from rs_lote_manutencao (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Aug 07 08 5 1s26ms 205ms 09 7 1s616ms 230ms 10 3 816ms 272ms 11 2 767ms 383ms 13 7 1s619ms 231ms 14 16 3s520ms 220ms 15 12 5s107ms 425ms 16 12 2s88ms 174ms 17 2 369ms 184ms [ User: intelifix - Total duration: 16s932ms - Times executed: 66 ]
[ Application: [unknown] - Total duration: 16s932ms - Times executed: 66 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"2", "cliente" :"1", "modelo" :"129", "usuario" :"407", "tipo" :"N", "itens" :"007", "nota-fiscal" :"11220", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}');
Date: 2026-08-07 15:34:44 Duration: 2s736ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"2", "cliente" :"1", "modelo" :"42", "usuario" :"413", "tipo" :"N", "itens" :"09", "nota-fiscal" :"11220", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}');
Date: 2026-08-07 13:14:58 Duration: 461ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"7", "cliente" :"11", "modelo" :"298", "usuario" :"428", "tipo" :"N", "itens" :"01", "nota-fiscal" :"2022", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}');
Date: 2026-08-07 11:48:33 Duration: 412ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
14 58 6m15s 1s790ms 18s179ms 6s468ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 07 07 4 34s441ms 8s610ms 08 5 46s38ms 9s207ms 09 1 9s401ms 9s401ms 10 9 1m13s 8s222ms 11 4 54s774ms 13s693ms 12 1 4s746ms 4s746ms 13 4 37s57ms 9s264ms 14 7 55s67ms 7s866ms 15 6 15s144ms 2s524ms 16 8 20s141ms 2s517ms 17 9 24s377ms 2s708ms [ User: intelifix - Total duration: 6m15s - Times executed: 58 ]
[ Application: [unknown] - Total duration: 6m15s - Times executed: 58 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-07', 0302, '', '', 0, 6, '2026-08-07');
Date: 2026-08-07 07:46:44 Duration: 18s179ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-07', 0175, '', '', 0, 6, '2026-08-01');
Date: 2026-08-07 13:44:58 Duration: 18s137ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-07', 0302, '', '', 0, 6, '2026-08-07');
Date: 2026-08-07 10:23:30 Duration: 17s56ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 57 3m19s 2s923ms 5s102ms 3s500ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 07 08 5 18s596ms 3s719ms 09 4 12s660ms 3s165ms 10 4 14s450ms 3s612ms 11 4 15s576ms 3s894ms 12 4 12s989ms 3s247ms 13 4 13s706ms 3s426ms 14 4 12s653ms 3s163ms 15 3 9s376ms 3s125ms 16 3 9s538ms 3s179ms 17 3 11s390ms 3s796ms 18 3 11s456ms 3s818ms 19 5 17s47ms 3s409ms 20 4 13s561ms 3s390ms 21 3 9s965ms 3s321ms 22 4 16s537ms 4s134ms [ User: intelifix - Total duration: 3m19s - Times executed: 57 ]
[ Application: psql - Total duration: 3m19s - Times executed: 57 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-07 22:20:10 Duration: 5s102ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-07 18:20:10 Duration: 4s406ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-07 11:20:09 Duration: 4s346ms Database: brasilia User: intelifix Remote: [local] Application: psql
16 55 12m2s 10s232ms 54s717ms 13s144ms create table temp0000287771 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Aug 07 07 12 2m18s 11s583ms 08 11 2m15s 12s292ms 09 13 2m44s 12s625ms 10 13 2m40s 12s334ms 11 6 2m4s 20s707ms [ User: intelifix - Total duration: 12m2s - Times executed: 55 ]
[ Application: [unknown] - Total duration: 12m2s - Times executed: 55 ]
-
CREATE TABLE temp0000287771 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-07 11:37:06 Duration: 54s717ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287771 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-07 11:39:23 Duration: 16s771ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287771 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-07 09:33:15 Duration: 15s97ms Database: rio User: intelifix Remote: [local] Application: [unknown]
17 53 10s810ms 150ms 336ms 203ms create table temp0000287753 as select * from rs_baixas_lista (?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Aug 07 07 5 1s26ms 205ms 08 6 1s97ms 182ms 09 7 1s334ms 190ms 10 10 2s111ms 211ms 11 25 5s240ms 209ms [ User: intelifix - Total duration: 10s810ms - Times executed: 53 ]
[ Application: [unknown] - Total duration: 10s810ms - Times executed: 53 ]
-
CREATE TABLE temp0000287753 AS SELECT * FROM RS_BAIXAS_LISTA (06, 00, 00, 0173, 00, '', '2026-08-05', '2026-08-07');
Date: 2026-08-07 07:20:09 Duration: 336ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287753 AS SELECT * FROM RS_BAIXAS_LISTA (06, 00, 00, 0173, 00, '922341029955', '2026-08-05', '2026-08-07');
Date: 2026-08-07 11:10:45 Duration: 327ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287753 AS SELECT * FROM RS_BAIXAS_LISTA (06, 00, 00, 0173, 00, '6802B85230C4', '2026-08-05', '2026-08-07');
Date: 2026-08-07 10:59:52 Duration: 314ms Database: rio User: intelifix Remote: [local] Application: [unknown]
18 50 15s360ms 151ms 911ms 307ms select * from rs_lote_saida_manutencao (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 07 06 1 186ms 186ms 07 6 1s796ms 299ms 08 14 5s905ms 421ms 09 7 1s422ms 203ms 10 4 1s660ms 415ms 11 7 1s476ms 210ms 12 1 288ms 288ms 13 4 1s268ms 317ms 14 2 568ms 284ms 17 4 786ms 196ms [ User: intelifix - Total duration: 15s360ms - Times executed: 50 ]
[ Application: [unknown] - Total duration: 15s360ms - Times executed: 50 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO ('{ "id" : "274905", "oficina" : "6", "cliente" : "5", "usuario" : "405", "nf" : "", "data-saida" : "", "sucata" : "N", "garantia" : "N", "fatura" : "", "data-fatura" : "", "data-inspecao" : "", "fechado" : "S", "valorado" : "", "motivo" : "0", "obs" : "", "def-extras" : "N", "acessorios" : "[]", "nf-vivo" : "0" }');
Date: 2026-08-07 08:41:41 Duration: 911ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO ('{ "id" : "131769", "oficina" : "7", "cliente" : "11", "usuario" : "428", "nf" : "", "data-saida" : "", "sucata" : "N", "garantia" : "N", "fatura" : "", "data-fatura" : "", "data-inspecao" : "", "fechado" : "N", "valorado" : "", "motivo" : "0", "obs" : "", "def-extras" : "N", "acessorios" : "[]", "nf-vivo" : "0" }');
Date: 2026-08-07 08:38:12 Duration: 884ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO ('{ "id" : "274907", "oficina" : "6", "cliente" : "5", "usuario" : "405", "nf" : "", "data-saida" : "", "sucata" : "N", "garantia" : "N", "fatura" : "", "data-fatura" : "", "data-inspecao" : "", "fechado" : "N", "valorado" : "", "motivo" : "0", "obs" : "", "def-extras" : "N", "acessorios" : "[]", "nf-vivo" : "0" }');
Date: 2026-08-07 10:01:54 Duration: 864ms Database: rio User: intelifix Remote: [local] Application: [unknown]
19 50 10s942ms 150ms 758ms 218ms select * from rs_produtividade_horas_html (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 07 01 1 236ms 236ms 05 1 345ms 345ms 07 3 1s462ms 487ms 10 4 737ms 184ms 11 5 1s11ms 202ms 12 4 828ms 207ms 13 5 908ms 181ms 14 8 1s687ms 210ms 15 10 2s36ms 203ms 16 7 1s328ms 189ms 17 2 359ms 179ms [ User: intelifix - Total duration: 10s942ms - Times executed: 50 ]
[ Application: [unknown] - Total duration: 10s942ms - Times executed: 50 ]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "398", "data-de" : "2026-08-06", "data-ate" : "2026-08-06", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 452 }');
Date: 2026-08-07 07:06:16 Duration: 758ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "432", "data-de" : "2026-08-06", "data-ate" : "2026-08-06", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 503 }');
Date: 2026-08-07 07:05:54 Duration: 531ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "396", "data-de" : "2026-08-07", "data-ate" : "2026-08-07", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 450 }');
Date: 2026-08-07 11:30:10 Duration: 347ms Database: rio User: intelifix Remote: [local] Application: [unknown]
20 48 2h11m15s 1s355ms 10m15s 2m44s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 07 07 3 10m14s 3m24s 08 3 10m37s 3m32s 09 3 9m59s 3m19s 10 3 9m6s 3m2s 11 3 10m56s 3m38s 12 3 9m38s 3m12s 13 3 6m29s 2m9s 14 3 8m13s 2m44s 15 3 9m21s 3m7s 16 3 6m34s 2m11s 17 3 6m32s 2m10s 18 3 6m4s 2m1s 19 3 5m54s 1m58s 20 3 8m56s 2m58s 21 3 6m22s 2m7s 22 3 6m10s 2m3s [ User: intelifix - Total duration: 2h11m15s - Times executed: 48 ]
[ Application: psql - Total duration: 2h11m15s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-07 11:15:16 Duration: 10m15s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-07 08:14:49 Duration: 9m48s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-07 07:14:27 Duration: 9m26s Database: rio User: intelifix Remote: [local] Application: psql
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 2m41s 10m20s 5m58s 3 17m54s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 07 05 3 17m54s 5m58s [ User: intelifix - Total duration: 17m54s - Times executed: 3 ]
[ Application: psql - Total duration: 17m54s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-08-07 05:10:22 Duration: 10m20s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-08-07 05:15:14 Duration: 4m52s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-08-07 05:17:56 Duration: 2m41s Database: contagem User: intelifix Remote: [local] Application: psql
2 1s355ms 10m15s 2m44s 48 2h11m15s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 07 07 3 10m14s 3m24s 08 3 10m37s 3m32s 09 3 9m59s 3m19s 10 3 9m6s 3m2s 11 3 10m56s 3m38s 12 3 9m38s 3m12s 13 3 6m29s 2m9s 14 3 8m13s 2m44s 15 3 9m21s 3m7s 16 3 6m34s 2m11s 17 3 6m32s 2m10s 18 3 6m4s 2m1s 19 3 5m54s 1m58s 20 3 8m56s 2m58s 21 3 6m22s 2m7s 22 3 6m10s 2m3s [ User: intelifix - Total duration: 2h11m15s - Times executed: 48 ]
[ Application: psql - Total duration: 2h11m15s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-07 11:15:16 Duration: 10m15s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-07 08:14:49 Duration: 9m48s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-07 07:14:27 Duration: 9m26s Database: rio User: intelifix Remote: [local] Application: psql
3 223ms 5m32s 1m51s 47 1h27m13s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 07 07 3 6m 2m 08 3 6m56s 2m18s 09 3 6m43s 2m14s 10 3 6m19s 2m6s 11 3 7m13s 2m24s 12 3 6m21s 2m7s 13 3 4m27s 1m29s 14 2 6m38s 3m19s 15 3 5m55s 1m58s 16 3 4m43s 1m34s 17 3 4m40s 1m33s 18 3 4m1s 1m20s 19 3 3m57s 1m19s 20 3 5m41s 1m53s 21 3 3m51s 1m17s 22 3 3m42s 1m14s [ User: intelifix - Total duration: 1h27m13s - Times executed: 47 ]
[ Application: psql - Total duration: 1h27m13s - Times executed: 47 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-07 11:23:03 Duration: 5m32s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-07 08:22:25 Duration: 5m28s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-07 14:19:47 Duration: 5m23s Database: brasilia User: intelifix Remote: [local] Application: psql
4 4s802ms 1m30s 47s318ms 4 3m9s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 07 20 2 1m35s 47s893ms 23 2 1m33s 46s743ms [ User: intelifix - Total duration: 3m9s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m9s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-07 20:08:50 Duration: 1m30s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-07 23:16:43 Duration: 1m27s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-07 23:36:35 Duration: 5s701ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
5 10s188ms 54s297ms 19s182ms 6 1m55s create table temp0000287651 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Aug 07 07 6 1m55s 19s182ms [ User: intelifix - Total duration: 1m55s - Times executed: 6 ]
[ Application: [unknown] - Total duration: 1m55s - Times executed: 6 ]
-
CREATE TABLE temp0000287651 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-07 07:02:25 Duration: 54s297ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287651 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-07 07:02:39 Duration: 13s685ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287651 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-07 07:05:40 Duration: 12s527ms Database: rio User: intelifix Remote: [local] Application: [unknown]
6 153ms 7m7s 19s17ms 199 1h3m4s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 07 06 3 1s581ms 527ms 07 13 8m1s 37s13ms 08 27 18m9s 40s358ms 09 27 8m9s 18s137ms 10 43 12m40s 17s691ms 11 19 7m42s 24s344ms 12 2 765ms 382ms 13 16 1m1s 3s823ms 14 13 1m1s 4s725ms 15 17 5m11s 18s308ms 16 2 1s175ms 587ms 17 9 23s724ms 2s636ms 18 8 39s530ms 4s941ms [ User: intelifix - Total duration: 1h3m4s - Times executed: 199 ]
[ Application: [unknown] - Total duration: 1h3m4s - Times executed: 199 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028193, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-07 11:46:57 Duration: 7m7s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028150, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-07 07:35:44 Duration: 6m45s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028190, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-07 10:36:45 Duration: 6m24s Database: rio User: intelifix Remote: [local] Application: [unknown]
7 10s317ms 56s556ms 13s288ms 40 8m51s create table temp0000287783 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 07 08 12 3m7s 15s642ms 09 17 3m29s 12s325ms 10 11 2m14s 12s209ms [ User: intelifix - Total duration: 8m51s - Times executed: 40 ]
[ Application: [unknown] - Total duration: 8m51s - Times executed: 40 ]
-
CREATE TABLE temp0000287783 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-07 08:46:49 Duration: 56s556ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287783 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-07 09:18:47 Duration: 16s305ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287783 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-07 09:31:19 Duration: 14s127ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 10s232ms 54s717ms 13s144ms 55 12m2s create table temp0000287771 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Aug 07 07 12 2m18s 11s583ms 08 11 2m15s 12s292ms 09 13 2m44s 12s625ms 10 13 2m40s 12s334ms 11 6 2m4s 20s707ms [ User: intelifix - Total duration: 12m2s - Times executed: 55 ]
[ Application: [unknown] - Total duration: 12m2s - Times executed: 55 ]
-
CREATE TABLE temp0000287771 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-07 11:37:06 Duration: 54s717ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287771 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-07 11:39:23 Duration: 16s771ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287771 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-07 09:33:15 Duration: 15s97ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 9s911ms 14s840ms 11s948ms 13 2m35s create table temp0000287753 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 07 09 13 2m35s 11s948ms [ User: intelifix - Total duration: 2m35s - Times executed: 13 ]
[ Application: [unknown] - Total duration: 2m35s - Times executed: 13 ]
-
CREATE TABLE temp0000287753 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-07 09:42:02 Duration: 14s840ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287753 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-07 09:54:19 Duration: 12s846ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287753 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-07 09:57:34 Duration: 12s822ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 1s787ms 25s79ms 7s238ms 25 3m select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel (?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 07 09 2 8s220ms 4s110ms 10 2 11s274ms 5s637ms 11 1 3s227ms 3s227ms 13 3 38s16ms 12s672ms 14 4 16s430ms 4s107ms 15 3 24s990ms 8s330ms 17 3 29s567ms 9s855ms 18 7 49s228ms 7s32ms [ User: intelifix - Total duration: 3m - Times executed: 25 ]
[ Application: psql - Total duration: 3m - Times executed: 25 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 398); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (04498);
Date: 2026-08-07 13:49:45 Duration: 25s79ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 420); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01623);
Date: 2026-08-07 17:18:18 Duration: 15s102ms Database: contagem User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 420); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01621);
Date: 2026-08-07 15:50:21 Duration: 13s147ms Database: contagem User: intelifix Remote: [local] Application: psql
11 1s790ms 18s179ms 6s468ms 58 6m15s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 07 07 4 34s441ms 8s610ms 08 5 46s38ms 9s207ms 09 1 9s401ms 9s401ms 10 9 1m13s 8s222ms 11 4 54s774ms 13s693ms 12 1 4s746ms 4s746ms 13 4 37s57ms 9s264ms 14 7 55s67ms 7s866ms 15 6 15s144ms 2s524ms 16 8 20s141ms 2s517ms 17 9 24s377ms 2s708ms [ User: intelifix - Total duration: 6m15s - Times executed: 58 ]
[ Application: [unknown] - Total duration: 6m15s - Times executed: 58 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-07', 0302, '', '', 0, 6, '2026-08-07');
Date: 2026-08-07 07:46:44 Duration: 18s179ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-07', 0175, '', '', 0, 6, '2026-08-01');
Date: 2026-08-07 13:44:58 Duration: 18s137ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-07', 0302, '', '', 0, 6, '2026-08-07');
Date: 2026-08-07 10:23:30 Duration: 17s56ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 150ms 24s92ms 3s691ms 41 2m31s select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 07 07 2 25s605ms 12s802ms 08 7 32s715ms 4s673ms 09 10 30s348ms 3s34ms 10 7 21s535ms 3s76ms 11 1 14s488ms 14s488ms 13 1 189ms 189ms 14 3 18s765ms 6s255ms 15 3 1s814ms 604ms 17 2 3s249ms 1s624ms 18 5 2s638ms 527ms [ User: intelifix - Total duration: 2m31s - Times executed: 41 ]
[ Application: psql - Total duration: 2m31s - Times executed: 41 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028161);
Date: 2026-08-07 08:51:19 Duration: 24s92ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028150);
Date: 2026-08-07 07:28:48 Duration: 19s653ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 184); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028194);
Date: 2026-08-07 14:02:26 Duration: 15s449ms Database: rio User: intelifix Remote: [local] Application: psql
13 2s961ms 5s887ms 3s519ms 33 1m56s call rs_tcia_processa_lotes () / 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 #13
Day Hour Count Duration Avg duration Aug 07 08 1 3s224ms 3s224ms 09 2 6s687ms 3s343ms 10 2 7s147ms 3s573ms 11 2 6s916ms 3s458ms 12 2 6s850ms 3s425ms 13 2 7s230ms 3s615ms 14 2 6s722ms 3s361ms 15 3 9s743ms 3s247ms 16 3 10s136ms 3s378ms 17 3 9s753ms 3s251ms 18 3 13s86ms 4s362ms 19 1 3s977ms 3s977ms 20 2 6s533ms 3s266ms 21 3 11s915ms 3s971ms 22 2 6s229ms 3s114ms [ User: intelifix - Total duration: 1m56s - Times executed: 33 ]
[ Application: psql - Total duration: 1m56s - Times executed: 33 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: 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-08-07 18:00:07 Duration: 5s887ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: 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-08-07 21:20:05 Duration: 4s615ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: 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-08-07 21:40:05 Duration: 4s230ms Database: rio User: intelifix Remote: [local] Application: psql
14 2s923ms 5s102ms 3s500ms 57 3m19s call rs_tcia_processa_lotes ();Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 07 08 5 18s596ms 3s719ms 09 4 12s660ms 3s165ms 10 4 14s450ms 3s612ms 11 4 15s576ms 3s894ms 12 4 12s989ms 3s247ms 13 4 13s706ms 3s426ms 14 4 12s653ms 3s163ms 15 3 9s376ms 3s125ms 16 3 9s538ms 3s179ms 17 3 11s390ms 3s796ms 18 3 11s456ms 3s818ms 19 5 17s47ms 3s409ms 20 4 13s561ms 3s390ms 21 3 9s965ms 3s321ms 22 4 16s537ms 4s134ms [ User: intelifix - Total duration: 3m19s - Times executed: 57 ]
[ Application: psql - Total duration: 3m19s - Times executed: 57 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-07 22:20:10 Duration: 5s102ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-07 18:20:10 Duration: 4s406ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-07 11:20:09 Duration: 4s346ms Database: brasilia User: intelifix Remote: [local] Application: psql
15 200ms 35s256ms 3s122ms 46 2m23s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 07 07 4 2s985ms 746ms 08 11 26s181ms 2s380ms 09 17 56s792ms 3s340ms 10 10 54s921ms 5s492ms 11 2 1s310ms 655ms 14 1 300ms 300ms 15 1 1s145ms 1s145ms [ User: intelifix - Total duration: 2m23s - Times executed: 46 ]
[ Application: psql - Total duration: 2m23s - Times executed: 46 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028166);
Date: 2026-08-07 09:19:05 Duration: 35s256ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028187);
Date: 2026-08-07 10:25:25 Duration: 22s953ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028184);
Date: 2026-08-07 10:09:29 Duration: 19s165ms Database: rio User: intelifix Remote: [local] Application: psql
16 207ms 22s905ms 3s28ms 146 7m22s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Aug 07 00 6 33s630ms 5s605ms 01 6 12s4ms 2s 02 5 12s754ms 2s550ms 03 6 18s170ms 3s28ms 04 6 15s715ms 2s619ms 05 5 17s476ms 3s495ms 07 10 31s83ms 3s108ms 08 12 57s187ms 4s765ms 09 12 50s368ms 4s197ms 10 12 49s373ms 4s114ms 11 12 34s191ms 2s849ms 12 12 23s221ms 1s935ms 13 11 28s179ms 2s561ms 14 6 11s258ms 1s876ms 15 6 11s74ms 1s845ms 16 6 5s57ms 842ms 17 3 2s403ms 801ms 21 4 15s880ms 3s970ms 22 6 13s186ms 2s197ms [ User: intelifix - Total duration: 7m22s - Times executed: 146 ]
[ Application: psql - Total duration: 7m22s - Times executed: 146 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-07 00:05:24 Duration: 22s905ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-07 07:35:12 Duration: 10s610ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-07 08:55:11 Duration: 10s288ms Database: rio User: intelifix Remote: [local] Application: psql
17 230ms 1m39s 2s989ms 276 13m45s call rs_giga_triagem (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Aug 07 00 12 35s729ms 2s977ms 01 12 23s864ms 1s988ms 02 12 24s954ms 2s79ms 03 12 28s983ms 2s415ms 04 12 25s404ms 2s117ms 05 12 25s357ms 2s113ms 06 12 24s855ms 2s71ms 07 12 27s782ms 2s315ms 08 12 35s570ms 2s964ms 09 12 29s560ms 2s463ms 10 12 3m8s 15s682ms 11 12 38s582ms 3s215ms 12 12 27s837ms 2s319ms 13 12 30s683ms 2s556ms 14 12 32s762ms 2s730ms 15 12 30s946ms 2s578ms 16 12 27s514ms 2s292ms 17 12 28s375ms 2s364ms 18 12 26s134ms 2s177ms 19 12 26s954ms 2s246ms 20 12 35s367ms 2s947ms 21 12 24s588ms 2s49ms 22 12 25s74ms 2s89ms [ User: intelifix - Total duration: 13m45s - Times executed: 276 ]
[ Application: psql - Total duration: 13m45s - Times executed: 276 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-07 10:36:46 Duration: 1m39s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-07 10:06:09 Duration: 1m Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-07 00:05:38 Duration: 13s894ms Database: rio User: intelifix Remote: [local] Application: psql
18 150ms 4s916ms 827ms 735 10m8s select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 07 07 37 25s423ms 687ms 08 141 1m28s 629ms 09 132 1m28s 673ms 10 96 1m11s 746ms 11 70 1m1s 882ms 12 49 43s213ms 881ms 13 37 43s366ms 1s172ms 14 74 1m28s 1s193ms 15 46 52s573ms 1s142ms 16 29 25s881ms 892ms 17 24 18s522ms 771ms [ User: intelifix - Total duration: 10m8s - Times executed: 735 ]
[ Application: [unknown] - Total duration: 10m8s - Times executed: 735 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (51823, 407, '834241935001415,241621459899,241631250419,241689194053,241727039092,241668288702,241668286883,241607291829,241710354154,241695648903,241664878403,241647341933,241665231726,241636081025,241671549615,241703714359,241656707784,241708948393,241689131623,241619346383,241637701430,241629854861,241680307697,230048398594,241717134344,241636110220,241661099100,241726982141,241646434055,241673360320', '',0321,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-07 14:12:35 Duration: 4s916ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (51906, 413, '835237935003807,241708857172,241637701329,241620818288,241675909513,241617420517,241731214248,241680371520,241604736977,241659797491,241663802125,241654614954,241614514363,241680371116,241731020414,241659806987,241714062743,241649802734,241622507791,241678327885,241636021524,241680344143,241614493654,241594129904,241654454860,241654459709,241704684970,241680340810,241614476884,241663104851,241656770620', '',0321,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-07 15:05:04 Duration: 4s661ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (275575, 450, '14011885850079203303,C85D385BB78F,C85D38884B4A,C85D38DCC392,C85D38F4017C,8C444FC140EE,C85D381478A5,C85D38793DCA,D86C5A00E6BC,C85D386EEFBF,C85D38105C1A,8C444FD61B1B,C85D380961F4,C85D38D71DE7,8C444FE9F791,C85D38A334EA,D86C5A3C2391,8C444FEBD79D,C85D38877713,C85D38F298A1,C85D38A13FC9,C85D386C3E9A,8C444FD93237,C85D380978EC,D86C5A015D45,C85D387BD6BC,,C85D3892B3FE,C85D380AF2D7,C85D38DCC464,C85D380D65F8,C85D38E4FF19,8C444FE08351,C85D38DCEE8E,C85D385AC567,C85D380E517B', '',0151,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-07 12:15:41 Duration: 3s918ms Database: rio User: intelifix Remote: [local] Application: [unknown]
19 150ms 9s849ms 614ms 946 9m41s select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 07 06 1 1s352ms 1s352ms 07 146 1m45s 720ms 08 160 1m47s 670ms 09 102 58s519ms 573ms 10 87 57s770ms 664ms 11 182 1m41s 555ms 12 12 8s380ms 698ms 13 130 1m17s 595ms 14 36 17s684ms 491ms 15 46 22s507ms 489ms 16 31 16s979ms 547ms 17 13 6s943ms 534ms [ User: intelifix - Total duration: 9m41s - Times executed: 946 ]
[ Application: [unknown] - Total duration: 9m41s - Times executed: 946 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "243112", "modelo" : "287", "itens" : "229954600115,230004952234,229995172626,229960077180,229997547784,229958241828,229921131012,229961382224,229965161224,229961413237,229993124850,229994759195,229970160814,229994567886,229997526671,229995722938,229992550822,230017167488,229938098403,229937944448", "usuario" : "414", "caixa" : "2912261", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-07 07:24:22 Duration: 9s849ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "275217", "modelo" : "141", "itens" : "229738110917,229884698095,229884320910,229663294748,229932958495,229740288098,229736602240,229884525980,229750374661,229741026262,229662039912,229860886467,229817142042,216932369600,216940466372,229740791616,216945262531,229782273038,229779255560,229933591824,229812187786,229781129705,229665023043,229690827592,229660501435,229780572749,229743129497,229689179003", "usuario" : "414", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "246547321535,226301794766,246165870110,246512400809,246340130102,246524003142,246529959806,246437745666,246245776280,246526994960,246488052024,246649006486,246630851314,246433457088,246474646585,246531100715,246456550106,246596669099,246559515575,246104638992,246461304868,246587289408,246467396573,246516352328,246423768095,246586804759,246546909091,246516047696,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-07 10:31:45 Duration: 2s872ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "274905", "modelo" : "141", "itens" : "229807520003,229741673251,229741640319,216945156684,229756118195,229741549298,229749726685,216943380810,229748059609,229686907490,229879499900,229671731835,229746140814,229808542235,229669095056,229687159816,229690505563,229751645862,229670359714,229740032440,229743426373,229780496579,229737738096,229753027781,229817128707,229669310409,229745749911,229805740716", "usuario" : "405", "caixa" : "3413885", "tecnico-cosmetico" : "299", "acessorios" : "246604990519,246526780215,246528242445,246461252944,246586338192,246570000213,246563321929,246471803749,246551382032,246513569597,246653280821,246495564059,246550074059,246618332236,246513641020,246517657797,246507042441,246532706774,246020080618,246569835572,246546137086,246583711416,246527598082,246529459195,246630914956,246514299804,246552200406,246596154751,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-07 08:42:16 Duration: 2s836ms Database: rio User: intelifix Remote: [local] Application: [unknown]
20 322ms 925ms 580ms 90 52s204ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 07 00 1 795ms 795ms 01 2 924ms 462ms 03 1 515ms 515ms 04 1 574ms 574ms 05 2 928ms 464ms 06 2 1s41ms 520ms 07 7 3s868ms 552ms 08 10 5s741ms 574ms 09 12 7s141ms 595ms 10 9 5s13ms 557ms 11 6 3s805ms 634ms 12 3 1s857ms 619ms 13 11 6s588ms 598ms 14 4 2s537ms 634ms 15 8 4s600ms 575ms 16 4 2s131ms 532ms 17 5 2s982ms 596ms 18 1 515ms 515ms 23 1 640ms 640ms [ User: intelifix - Total duration: 52s204ms - Times executed: 90 ]
[ Application: [unknown] - Total duration: 52s204ms - Times executed: 90 ]
-
select * from rs_menu_grants (397, 18, 1);
Date: 2026-08-07 11:00:11 Duration: 925ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (80, 18, 1);
Date: 2026-08-07 09:30:14 Duration: 891ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (416, 21, 1);
Date: 2026-08-07 13:59:34 Duration: 856ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 7 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Aug 07 09 1 0ms 0ms 12 1 0ms 0ms 13 2 0ms 0ms 19 1 0ms 0ms 20 2 0ms 0ms [ User: intelifix - Total duration: 11s503ms - Times executed: 7 ]
[ Application: psql - Total duration: 9s398ms - Times executed: 4 ]
[ Application: [unknown] - Total duration: 2s104ms - Times executed: 3 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 15,385 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 21 FATAL entries
- 3024 ERROR entries
- 0 WARNING entries
- 8 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 2,960 Max number of times the same event was reported
- 3,053 Total events found
Rank Times reported Error 1 2,960 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Aug 07 00 59 01 60 02 59 03 59 04 60 05 60 06 59 07 113 08 280 09 355 10 289 11 281 12 193 13 160 14 163 15 121 16 146 17 95 18 60 19 60 20 59 21 60 22 59 23 50 - ERROR: prepared statement "_PLAN0000000029B10C10" does not exist
- ERROR: prepared statement "_PLAN00000000298BC130" does not exist
- ERROR: prepared statement "_PLAN0000000029B0D0C0" does not exist
Statement: DEALLOCATE "_PLAN0000000029B10C10"
Date: 2026-08-07 00:00:41 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN00000000298BC130"
Date: 2026-08-07 00:01:41 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029B0D0C0"
Date: 2026-08-07 00:02:42 Database: rio Application: [unknown] User: etiquetas Remote: [local]
2 46 ERROR: PermissionError: ... Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
Times Reported Most Frequent Error / Event #2
Day Hour Count Aug 07 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-08-07 00:05:02 Database: brasilia Application: psql User: intelifix Remote: [local]
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-08-07 00:35:01 Database: brasilia Application: psql User: intelifix Remote: [local]
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-08-07 01:05:01 Database: brasilia Application: psql User: intelifix Remote: [local]
3 10 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #3
Day Hour Count Aug 07 03 10 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-08-07 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-08-07 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-08-07 03:05:01 Database: rio Application: [unknown] User: lenon Remote: [local]
4 9 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #4
Day Hour Count Aug 07 00 1 02 1 06 5 12 1 14 1 - FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
- FATAL: database "testes" does not exist
Date: 2026-08-07 00:02:13 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-08-07 02:17:44 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
Date: 2026-08-07 06:02:11 Database: testes Application: [unknown] User: lenon Remote: [local]
5 6 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #5
Day Hour Count Aug 07 09 6 - ERROR: syntax error at or near "C85D38DD1B43" at character 79
- ERROR: syntax error at or near "C85D38DD1B43" at character 79
- ERROR: syntax error at or near "C85D38DD1B43" at character 79
Statement: SELECT RS_SERIAL_TEMPORARIO( 'C85D38DD1B43'' ) OR RS_SERIAL_TEMPORARIO_VIVO( 'C85D38DD1B43'' )
Date: 2026-08-07 09:57:22 Database: rio Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT RS_SERIAL_TEMPORARIO( 'C85D38DD1B43'' ) OR RS_SERIAL_TEMPORARIO_VIVO( 'C85D38DD1B43'' ) NOTICE: table "tmp_entrada" does not exist, skipping
Date: 2026-08-07 09:57:58 Database: rio Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT RS_SERIAL_TEMPORARIO( 'C85D38DD1B43'' ) OR RS_SERIAL_TEMPORARIO_VIVO( 'C85D38DD1B43'' )
Date: 2026-08-07 09:58:51 Database: rio Application: [unknown] User: intelifix Remote: [local]
6 5 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #6
Day Hour Count Aug 07 05 5 - ERROR: relation "temp0000287737" does not exist at character 15
- ERROR: relation "rs_mv_equipamentos" does not exist
- ERROR: relation "rs_mv_codigos_barra" does not exist
Statement: SELECT * FROM temp0000287737
Date: 2026-08-07 05:13:46 Database: rio Application: [unknown] User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-07 05:32:19 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-07 05:32:19 Database: brasilia Application: psql User: intelifix Remote: [local]
7 4 LOG: process ... still waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #7
Day Hour Count Aug 07 10 4 - LOG: process 1087420 still waiting for ShareLock on transaction 4022610 after 1000.054 ms
- LOG: process 1087420 still waiting for ShareLock on transaction 4022610 after 21397.672 ms
- LOG: process 1087436 still waiting for ShareLock on transaction 4024914 after 1000.175 ms
Detail: Process holding the lock: 1082899. Wait queue: 1087420.
Context: while updating tuple (76077,75) 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-08-07 10:05:14 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Process holding the lock: 1082899. Wait queue: 1087420.
Context: while updating tuple (76077,75) 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-08-07 10:05:34 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Process holding the lock: 1069662. Wait queue: 1087436.
Context: while updating tuple (76093,23) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-08-07 10:35:11 Database: rio Application: psql User: intelifix Remote: [local]
8 2 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #8
Day Hour Count Aug 07 03 2 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-08-07 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
Date: 2026-08-07 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
9 2 ERROR: trailing junk after numeric literal at or near "..."
Times Reported Most Frequent Error / Event #9
Day Hour Count Aug 07 09 2 - ERROR: trailing junk after numeric literal at or near "50023822FC70" at character 27
- ERROR: trailing junk after numeric literal at or near "50023822FC70" at character 27
Statement: select * from rs_caixa_qr(50023822FC70)
Date: 2026-08-07 09:16:51 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(50023822FC70)
Date: 2026-08-07 09:16:51 Database: rio Application: [unknown] User: etiquetas Remote: [local]
10 2 LOG: process ... still waiting for ExclusiveLock on relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #10
Day Hour Count Aug 07 15 2 - LOG: process 1277406 still waiting for ExclusiveLock on relation 374564 of database 358222 after 1000.136 ms
- LOG: process 1277406 still waiting for ExclusiveLock on relation 374564 of database 358222 after 2462.447 ms
Detail: Process holding the lock: 1270524. Wait queue: 1277406.
Context: SQL statement "REFRESH MATERIALIZED VIEW CONCURRENTLY RS_V_LOTES_REDE" PL/pgSQL function rs_atualiza_views() line 17 at SQL statement SQL statement "CALL RS_ATUALIZA_VIEWS()" PL/pgSQL function rs_lote_manutencao(text) line 361 at CALL
Statement: SELECT * FROM RS_LOTE_MANUTENCAO('{ "id" :"0", "oficina" :"2", "cliente" :"1", "modelo" :"129", "usuario" :"407", "tipo" :"N", "itens" :"007", "nota-fiscal" :"11220", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}')Date: 2026-08-07 15:34:43 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Detail: Process holding the lock: 1270524. Wait queue: 1277406.
Context: SQL statement "REFRESH MATERIALIZED VIEW CONCURRENTLY RS_V_LOTES_REDE" PL/pgSQL function rs_atualiza_views() line 17 at SQL statement SQL statement "CALL RS_ATUALIZA_VIEWS()" PL/pgSQL function rs_lote_manutencao(text) line 361 at CALL
Statement: SELECT * FROM RS_LOTE_MANUTENCAO('{ "id" :"0", "oficina" :"2", "cliente" :"1", "modelo" :"129", "usuario" :"407", "tipo" :"N", "itens" :"007", "nota-fiscal" :"11220", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}')Date: 2026-08-07 15:34:44 Database: contagem Application: [unknown] User: intelifix Remote: [local]
11 2 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #11
Day Hour Count Aug 07 13 2 - ERROR: column "c85d3872efa9" does not exist at character 27
- ERROR: column "c85d3872efa9" does not exist at character 27
Statement: select * from rs_caixa_qr(C85D3872EFA9)
Date: 2026-08-07 13:49:14 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(C85D3872EFA9)
Date: 2026-08-07 13:49:14 Database: rio Application: [unknown] User: etiquetas Remote: [local]
12 1 ERROR: canceling autovacuum task
Times Reported Most Frequent Error / Event #12
Day Hour Count Aug 07 11 1 - ERROR: canceling autovacuum task
Context: automatic vacuum of table "rio.public.temp0000287771"
Date: 2026-08-07 11:37:33
13 1 ERROR: date/time field value out of range: "..."
Times Reported Most Frequent Error / Event #13
Day Hour Count Aug 07 05 1 - ERROR: date/time field value out of range: "3255-84-22" at character 94
Hint: Perhaps you need a different "DateStyle" setting.
Statement: CREATE TABLE temp0000287737 AS SELECT * FROM RS_BAIXAS_LISTA(06,00,00,0428,00,'229847325559','3255-84-22','2026-08-07');Date: 2026-08-07 05:13:46 Database: rio Application: [unknown] User: intelifix Remote: [local]
14 1 LOG: process ... still waiting for AccessExclusiveLock on relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #14
Day Hour Count Aug 07 11 1 - LOG: process 1132519 still waiting for AccessExclusiveLock on relation 3533710 of database 358220 after 1000.169 ms
Detail: Process holding the lock: 1160109. Wait queue: 1132519.
Statement: DROP TABLE IF EXISTS temp0000287771;Date: 2026-08-07 11:37:33 Database: rio Application: [unknown] User: intelifix Remote: [local]
15 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #15
Day Hour Count Aug 07 03 1 - LOG: database system was shut down at 2026-08-07 03:05:01 -03
Date: 2026-08-07 03:05:02
16 1 ERROR: unterminated quoted identifier at or near ""..."
Times Reported Most Frequent Error / Event #16
Day Hour Count Aug 07 09 1 - ERROR: unterminated quoted identifier at or near ""}]}')" at character 107
Statement: SELECT * FROM RS_LOTE_CONSISTE_SERIAL( '{"lote":"275339","seriais":[{"serial":""},{"serial":"C85D38DD1B43'"}]}')
Date: 2026-08-07 09:59:00 Database: rio Application: [unknown] User: intelifix Remote: [local]