pgBadger-
Global information
- Generated on Thu Jul 9 23:50:13 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 45,115 log entries in 11s
- Log start from 2026-07-09 00:00:03 to 2026-07-09 23:50:03
-
Overview
Global Stats
- 390 Number of unique normalized queries
- 6,497 Number of queries
- 8h22m28s Total query duration
- 2026-07-09 00:02:07 First query
- 2026-07-09 23:50:03 Last query
- 5 queries/s at 2026-07-09 11:06:12 Query peak
- 8h22m28s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 8h22m28s Execute total duration
- 4,615 Number of events
- 16 Number of unique normalized events
- 4,425 Max number of times the same event was reported
- 0 Number of cancellation
- 440 Total number of automatic vacuums
- 949 Total number of automatic analyzes
- 14 Number temporary file
- 234.13 MiB Max size of temporary file
- 129.76 MiB Average size of temporary file
- 359 Total number of sessions
- 7 sessions at 2026-07-09 12:22:06 Session peak
- 13d10h13m34s Total duration of sessions
- 53m51s Average duration of sessions
- 18 Average queries per session
- 1m23s Average queries duration per session
- 52m27s Average idle time per session
- 362 Total number of connections
- 5 connections/s at 2026-07-09 00:05:01 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 5 queries/s Query Peak
- 2026-07-09 11:06:12 Date
SELECT Traffic
Key values
- 4 queries/s Query Peak
- 2026-07-09 09:25:14 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 3 queries/s Query Peak
- 2026-07-09 20:09:43 Date
Queries duration
Key values
- 8h22m28s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 09 00 25 0ms 18s689ms 4s644ms 4s951ms 6s789ms 1m19s 01 34 0ms 5s804ms 1s284ms 5s56ms 6s855ms 10s266ms 02 17 0ms 5s692ms 2s268ms 5s399ms 5s920ms 8s454ms 03 19 0ms 14s561ms 2s594ms 4s653ms 7s450ms 16s227ms 04 26 0ms 5s151ms 1s682ms 5s496ms 7s307ms 7s497ms 05 42 0ms 8m36s 25s166ms 9s869ms 2m15s 8m37s 06 23 0ms 9s285ms 3s99ms 5s196ms 6s799ms 33s13ms 07 245 0ms 9m14s 8s12ms 44s335ms 4m43s 9m17s 08 657 150ms 8m17s 3s12ms 46s433ms 4m50s 8m18s 09 646 150ms 9m24s 3s106ms 47s35ms 5m2s 9m31s 10 595 150ms 9m19s 3s449ms 57s556ms 4m16s 9m21s 11 723 150ms 9m13s 3s23ms 46s912ms 4m54s 9m24s 12 216 0ms 7m52s 6s968ms 35s550ms 4m24s 7m52s 13 403 0ms 8m3s 4s493ms 48s365ms 2m13s 11m40s 14 923 150ms 9m4s 3s132ms 1m25s 5m37s 9m11s 15 619 150ms 9m15s 4s38ms 1m36s 5m17s 9m24s 16 482 150ms 8m43s 4s535ms 40s75ms 5m16s 9m11s 17 334 0ms 8m52s 3s779ms 26s77ms 1m16s 9m23s 18 61 0ms 6m14s 11s751ms 5s841ms 26s341ms 6m58s 19 21 0ms 5m39s 29s520ms 4s558ms 45s618ms 5m39s 20 106 0ms 7m17s 12s605ms 1m4s 2m21s 7m17s 21 33 0ms 6m 20s304ms 6s72ms 11s595ms 6m48s 22 27 0ms 5m59s 24s30ms 5s102ms 6s869ms 6m47s 23 220 0ms 2m15s 10s883ms 1m19s 1m33s 3m2s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 09 00 4 0 1s703ms 0ms 0ms 235ms 01 17 0 270ms 153ms 189ms 1s220ms 02 0 0 0ms 0ms 0ms 0ms 03 1 0 153ms 0ms 0ms 0ms 04 8 0 337ms 0ms 0ms 958ms 05 20 0 320ms 164ms 349ms 1s316ms 06 5 0 1s465ms 0ms 0ms 782ms 07 174 0 9s241ms 5s694ms 12s979ms 5m5s 08 473 0 3s240ms 10s203ms 21s115ms 5m29s 09 509 0 3s284ms 8s681ms 44s537ms 6m3s 10 435 0 3s666ms 9s350ms 36s74ms 5m24s 11 549 0 3s229ms 11s278ms 27s730ms 5m2s 12 145 0 8s617ms 5s138ms 14s137ms 5m16s 13 313 0 4s944ms 15s994ms 29s523ms 4m18s 14 775 0 2s958ms 20s131ms 46s326ms 5m45s 15 511 0 4s330ms 14s862ms 1m19s 5m46s 16 359 0 5s203ms 11s755ms 22s210ms 5m22s 17 216 0 5s272ms 7s578ms 17s620ms 4m26s 18 27 0 24s673ms 0ms 2s314ms 3m28s 19 6 0 1m38s 0ms 0ms 3m25s 20 9 83 14s135ms 40s730ms 1m4s 3m37s 21 13 0 48s46ms 0ms 0ms 3m33s 22 6 0 1m41s 0ms 0ms 3m23s 23 7 213 10s883ms 1m4s 1m19s 2m8s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 09 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Jul 09 00 0 0 0.00 0.00% 01 0 2 2.00 0.00% 02 0 0 0.00 0.00% 03 0 1 1.00 0.00% 04 0 2 2.00 0.00% 05 0 2 2.00 0.00% 06 0 1 1.00 0.00% 07 0 16 16.00 0.00% 08 0 11 11.00 0.00% 09 0 9 9.00 0.00% 10 0 15 15.00 0.00% 11 0 13 13.00 0.00% 12 0 11 11.00 0.00% 13 0 15 15.00 0.00% 14 0 14 14.00 0.00% 15 0 16 16.00 0.00% 16 0 13 13.00 0.00% 17 0 5 5.00 0.00% 18 0 2 2.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 2 2.00 0.00% 22 0 0 0.00 0.00% 23 0 1 1.00 0.00% Day Hour Count Average / Second Jul 09 00 17 0.00/s 01 13 0.00/s 02 9 0.00/s 03 18 0.01/s 04 10 0.00/s 05 9 0.00/s 06 14 0.00/s 07 20 0.01/s 08 22 0.01/s 09 17 0.00/s 10 19 0.01/s 11 24 0.01/s 12 14 0.00/s 13 22 0.01/s 14 23 0.01/s 15 26 0.01/s 16 22 0.01/s 17 14 0.00/s 18 11 0.00/s 19 8 0.00/s 20 12 0.00/s 21 9 0.00/s 22 6 0.00/s 23 3 0.00/s Day Hour Count Average Duration Average idle time Jul 09 00 4 1h 59m31s 01 16 1h1m6s 1h1m3s 02 12 1h15s 1h12s 03 19 25m56s 25m53s 04 8 1h3m 1h2m54s 05 9 1h42s 58m45s 06 9 56m55s 56m47s 07 15 57m48s 55m37s 08 18 58m43s 56m53s 09 22 59m16s 57m44s 10 19 51m13s 49m25s 11 22 50m48s 49m9s 12 21 55m43s 54m32s 13 15 50m37s 48m36s 14 21 58m27s 56m10s 15 27 48m15s 46m43s 16 23 54m56s 53m21s 17 20 54m15s 53m11s 18 13 58m4s 57m9s 19 12 56m33s 55m42s 20 11 40m10s 38m8s 21 8 1h45s 59m21s 22 9 57m 55m48s 23 6 55m40s 49m1s -
Connections
Established Connections
Key values
- 5 connections Connection Peak
- 2026-07-09 00:05:01 Date
Connections per database
Key values
- rio Main Database
- 362 connections Total
Connections per user
Key values
- intelifix Main User
- 362 connections Total
-
Sessions
Simultaneous sessions
Key values
- 7 sessions Session Peak
- 2026-07-09 12:22:06 Date
Histogram of session times
Key values
- 291 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 359 sessions Total
Sessions per user
Key values
- intelifix Main User
- 359 sessions Total
Sessions per host
Key values
- [local] Main Host
- 359 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 14,276 buffers Checkpoint Peak
- 2026-07-09 09:39:37 Date
- 270.003 seconds Highest write time
- 0.117 seconds Sync time
Checkpoints Wal files
Key values
- 10 files Wal files usage Peak
- 2026-07-09 14:39:39 Date
Checkpoints distance
Key values
- 332.48 Mo Distance Peak
- 2026-07-09 14:39:39 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jul 09 00 18,184 656.301s 0.047s 656.401s 01 2,918 292.978s 0.043s 293.079s 02 1,552 156.006s 0.023s 156.068s 03 1,604 161.281s 0.043s 161.373s 04 2,347 235.89s 0.032s 235.962s 05 10,492 973.801s 0.079s 973.956s 06 7,292 507.196s 0.011s 507.242s 07 35,704 2,439.75s 0.281s 2,440.177s 08 49,508 3,138.908s 0.693s 3,139.829s 09 69,675 3,185.775s 0.617s 3,186.623s 10 54,330 3,208.943s 0.553s 3,209.736s 11 61,614 3,199.721s 0.669s 3,200.633s 12 35,203 2,546.433s 0.191s 2,546.772s 13 41,130 2,648.468s 0.544s 2,649.199s 14 84,114 3,238.533s 0.768s 3,239.607s 15 73,902 3,238.921s 0.598s 3,239.716s 16 50,476 3,182.913s 0.528s 3,183.643s 17 26,376 2,147.895s 0.461s 2,148.524s 18 7,696 706.719s 0.051s 706.829s 19 30 3.037s 0.004s 3.049s 20 1,576 221.501s 0.022s 221.542s 21 2,938 295.11s 0.03s 295.217s 22 1,994 200.392s 0.029s 200.467s 23 906 90.792s 0.012s 90.842s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jul 09 00 0 0 6 422 0.010s 0.006s 01 0 0 1 524 0.003s 0.008s 02 0 0 1 338 0.003s 0.005s 03 0 0 0 366 0.004s 0.006s 04 0 0 1 478 0.003s 0.005s 05 0 0 4 878 0.003s 0.009s 06 0 0 2 155 0.001s 0.003s 07 0 0 23 3,849 0.003s 0.012s 08 0 0 25 6,887 0.008s 0.012s 09 0 0 33 6,430 0.005s 0.012s 10 0 0 38 6,015 0.005s 0.012s 11 0 0 36 6,654 0.013s 0.012s 12 0 0 20 3,480 0.003s 0.012s 13 0 0 26 5,796 0.019s 0.012s 14 0 0 62 7,150 0.009s 0.012s 15 0 0 31 6,592 0.007s 0.012s 16 0 0 26 5,672 0.005s 0.012s 17 0 0 16 4,796 0.005s 0.012s 18 0 0 5 705 0.003s 0.007s 19 0 0 0 11 0.002s 0.001s 20 0 0 1 87 0.002s 0.003s 21 0 0 1 511 0.003s 0.008s 22 0 0 0 420 0.003s 0.007s 23 0 0 2 33 0.002s 0.004s Day Hour Count Avg time (sec) Jul 09 00 0 0s 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s 23 0 0s Day Hour Mean distance Mean estimate Jul 09 00 16,914.50 kB 51,521.33 kB 01 1,874.75 kB 29,895.38 kB 02 1,670.00 kB 15,639.00 kB 03 1,284.14 kB 3,904.14 kB 04 2,326.60 kB 3,312.80 kB 05 7,804.33 kB 16,714.33 kB 06 6,820.00 kB 13,231.33 kB 07 31,555.83 kB 63,157.92 kB 08 34,841.50 kB 73,341.67 kB 09 44,270.00 kB 94,857.92 kB 10 52,259.58 kB 84,408.83 kB 11 49,656.08 kB 78,026.50 kB 12 26,880.42 kB 66,359.50 kB 13 35,992.00 kB 52,031.25 kB 14 83,427.75 kB 131,252.25 kB 15 43,339.08 kB 95,538.42 kB 16 35,621.50 kB 66,439.83 kB 17 21,158.17 kB 50,439.75 kB 18 10,899.14 kB 27,593.14 kB 19 196.00 kB 34,592.00 kB 20 5,673.00 kB 29,478.67 kB 21 2,130.29 kB 18,534.14 kB 22 1,525.43 kB 9,805.86 kB 23 9,269.25 kB 20,593.00 kB -
Temporary Files
Size of temporary files
Key values
- 468.27 MiB Temp Files size Peak
- 2026-07-09 05:32:00 Date
Number of temporary files
Key values
- 2 per second Temp Files Peak
- 2026-07-09 05:30:39 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jul 09 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 10 1.06 GiB 108.86 MiB 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 1 182.00 MiB 182.00 MiB 12 0 0 0 13 3 546.03 MiB 182.01 MiB 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 8 909.57 MiB 69.84 MiB 234.13 MiB 113.70 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-09 05:32:09 Duration: 1m26s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-09 05:32:00 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 4 728.03 MiB 182.00 MiB 182.01 MiB 182.01 MiB select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel (?);-
SELECT RS_SETGLOBAL ('USUARIO', 406); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01511);
Date: 2026-07-09 11:43:38 Duration: 2m3s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
SELECT RS_SETGLOBAL ('USUARIO', 406); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01514);
Date: 2026-07-09 13:26:19 Duration: 1m54s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
SELECT RS_SETGLOBAL ('USUARIO', 406); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01512);
Date: 2026-07-09 13:13:10 Duration: 1m51s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-09.log
3 2 178.98 MiB 89.49 MiB 89.49 MiB 89.49 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-09 05:30:42 Duration: 41s237ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-09 05:30:39 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
Queries generating the largest temporary files
Rank Size Query 1 234.13 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-09 05:32:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 234.13 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-09 05:32:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 182.01 MiB SELECT RS_SETGLOBAL ('USUARIO', 406); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01512);[ Date: 2026-07-09 13:13:08 - Database: contagem - User: intelifix - Remote: [local] - Application: psql ]
4 182.01 MiB SELECT RS_SETGLOBAL ('USUARIO', 406); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01513);[ Date: 2026-07-09 13:13:53 - Database: contagem - User: intelifix - Remote: [local] - Application: psql ]
5 182.01 MiB SELECT RS_SETGLOBAL ('USUARIO', 406); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01514);[ Date: 2026-07-09 13:26:18 - Database: contagem - User: intelifix - Remote: [local] - Application: psql ]
6 182.00 MiB SELECT RS_SETGLOBAL ('USUARIO', 406); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01511);[ Date: 2026-07-09 11:43:38 - Database: contagem - User: intelifix - Remote: [local] - Application: psql ]
7 89.49 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-07-09 05:30:39 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 89.49 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-07-09 05:30:39 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 77.29 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-09 05:32:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 77.22 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-09 05:32:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 77.21 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-09 05:32:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 69.91 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-09 05:32:09 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 69.85 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-09 05:32:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 69.84 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-09 05:32:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 16.11 sec Highest CPU-cost vacuum
Table public.giga_testes
Database rio - 2026-07-09 14:16:01 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 16.11 sec Highest CPU-cost vacuum
Table public.giga_testes
Database rio - 2026-07-09 14:16:01 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (98) Main table analyzed (database rio)
- 949 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 98 rio.public.temp0000284888 55 rio.pg_catalog.pg_class 53 rio.public.usuarios 49 rio.pg_catalog.pg_type 45 contagem.pg_catalog.pg_attribute 44 brasilia.pg_catalog.pg_attribute 42 rio.pg_catalog.pg_index 29 rio.public.temp0000284910 24 rio.pg_catalog.pg_depend 23 rio.public.temp0000284964 22 contagem.public.usuarios 22 brasilia.pg_catalog.pg_class 21 contagem.pg_catalog.pg_class 20 brasilia.pg_catalog.pg_type 18 rio.public.temp0000284988 18 contagem.pg_catalog.pg_type 17 rio.public.temp0000284750 16 rio.public.temp0000284968 14 contagem.public.temp0000226520 12 brasilia.pg_catalog.pg_index 12 contagem.pg_catalog.pg_index 11 rio.public.temp0000284664 11 brasilia.pg_catalog.pg_depend 10 rio.public.temp0000284904 9 brasilia.public.temp0000235780 9 rio.public.temp0000284878 9 brasilia.public.usuarios 9 rio.public.temp0000284896 9 rio.public.temp0000284954 9 rio.public.temp0000284882 9 rio.public.temp0000284920 9 brasilia.public.temp0000235798 8 rio.public.temp0000284946 8 brasilia.public.temp0000235698 8 contagem.pg_catalog.pg_depend 8 rio.public.temp0000284914 8 brasilia.public.temp0000235704 7 rio.public.temp0000284798 7 rio.public.temp0000284762 7 rio.public.temp0000284982 6 rio.public.temp0000284950 6 brasilia.public.temp0000235818 6 contagem.public.temp0000226579 5 rio.pg_catalog.pg_shdepend 5 rio.public.temp0000284984 4 rio.public.tmp_drill_0175 4 brasilia.public.temp0000235792 4 contagem.public.temp0000226583 3 contagem.public.nf_entrada 3 rio.public.temp0000284972 3 brasilia.pg_catalog.pg_shdepend 3 rio.public.temp0000284884 3 brasilia.public.nf_entrada 3 brasilia.public.temp0000235836 3 rio.public.temp0000284900 3 brasilia.public.temp0000235774 3 rio.public.temp0000284916 3 brasilia.public.temp0000235752 2 contagem.public.temp0000226591 2 contagem.pg_catalog.pg_shdepend 2 postgres.pg_catalog.pg_shdepend 2 brasilia.public.temp0000235694 2 brasilia.public.temp0000235760 2 rio.public.temp0000284974 2 brasilia.public.temp0000235826 2 rio.public.temp0000284966 2 brasilia.public.temp0000235756 2 contagem.public.temp0000226589 2 brasilia.public.temp0000235746 2 rio.public.temp0000284918 1 rio.public.temp0000284880 1 brasilia.public.temp0000235700 1 rio.public.temp0000284986 1 brasilia.public.temp0000235764 1 brasilia.public.temp0000235828 1 rio.auditor.auditor_2026_07 1 brasilia.public.temp0000235724 1 brasilia.public.temp0000235812 1 brasilia.public.temp0000235822 1 rio.public.temp0000283926 1 brasilia.public.temp0000235784 1 brasilia.public.temp0000235796 1 rio.public.temp0000284912 1 template1.pg_catalog.pg_shdepend 1 rio.public.temp0000284970 1 brasilia.public.temp0000235820 1 contagem.public.temp0000226575 1 rio.public.temp0000284898 1 brasilia.auditor.auditor_2026_07 1 contagem.auditor.auditor_2026_07 1 brasilia.public.temp0000235824 1 brasilia.public.temp0000235766 1 rio.public.temp0000284992 1 brasilia.public.temp0000235710 1 rio.public.temp0000284316 1 brasilia.public.temp0000235832 1 brasilia.public.temp0000235712 1 rio.public.temp0000284976 1 brasilia.public.temp0000235750 1 rio.public.temp0000284886 1 brasilia.public.temp0000235730 1 rio.public.temp0000284962 1 rio.public.temp0000284956 1 brasilia.public.temp0000235758 1 brasilia.public.temp0000235834 1 Total 949 Vacuums per table
Key values
- public.temp0000284888 (55) Main table vacuumed on database rio
- 440 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples rio.public.temp0000284888 55 0 0 0 0 0 0 29,610 458 2,127,564 0 0 rio.pg_catalog.pg_attribute 35 34 0 0 0 0 0 17,928 4,508 7,001,811 280 6,975 rio.pg_catalog.pg_class 22 20 0 0 0 0 0 4,341 1,393 1,926,732 69 266 contagem.public.usuarios 22 0 0 0 0 0 0 112 80 50,066 0 0 rio.pg_catalog.pg_type 19 18 0 0 0 0 0 1,779 554 710,105 58 191 contagem.pg_catalog.pg_attribute 18 16 0 0 0 0 0 8,787 2,030 3,761,378 24 600 rio.public.temp0000284968 15 0 0 0 0 0 0 16,441 55 978,739 0 0 rio.public.temp0000284988 14 0 0 0 0 0 0 4,695 212 520,131 0 0 brasilia.pg_catalog.pg_attribute 13 13 0 0 0 0 0 7,860 2,082 3,328,839 84 2,190 rio.pg_catalog.pg_index 12 10 0 0 0 0 0 475 134 152,075 26 72 rio.public.temp0000284750 11 0 0 0 0 0 0 683 60 48,726 0 0 contagem.pg_catalog.pg_class 10 8 0 0 0 0 0 1,407 227 382,522 12 38 rio.pg_catalog.pg_depend 10 10 0 0 0 0 0 3,622 1,305 1,902,479 68 530 rio.public.temp0000284896 10 0 0 0 0 0 0 8,231 1,673 2,591,208 0 0 contagem.pg_catalog.pg_type 10 8 0 0 0 0 0 748 166 285,009 6 24 rio.public.temp0000284664 9 0 0 0 0 0 0 818 152 227,614 0 0 brasilia.pg_catalog.pg_class 8 8 0 0 0 0 0 1,624 408 710,501 16 77 rio.public.usuarios 8 5 0 0 0 0 0 161 74 192,205 10 20 rio.pg_catalog.pg_statistic 8 8 0 0 0 0 0 9,876 2,250 10,334,992 938 4,039 template1.pg_catalog.pg_shdepend 7 7 0 0 0 0 0 1,238 411 788,838 105 213 rio.public.temp0000284798 7 0 0 0 0 0 0 271 35 21,178 0 0 rio.public.temp0000284762 7 0 0 0 0 0 0 602 100 141,716 0 0 rio.public.temp0000284910 7 0 0 0 0 0 0 1,829 30 112,739 0 0 brasilia.pg_catalog.pg_type 7 7 0 0 0 0 0 674 184 277,219 19 103 rio.public.temp0000284950 6 0 0 0 0 0 0 8,310 1,665 2,596,050 0 0 contagem.public.temp0000226579 5 0 0 0 0 0 0 229 27 17,991 0 0 brasilia.pg_catalog.pg_index 5 5 0 0 0 0 0 247 69 61,204 14 36 contagem.pg_catalog.pg_depend 5 5 0 0 0 0 0 1,516 446 939,508 6 284 contagem.pg_catalog.pg_index 5 5 0 0 0 0 0 232 76 72,615 6 8 rio.public.tmp_drill_0175 4 4 0 0 0 0 0 185 12 37,352 0 0 rio.pg_toast.pg_toast_2619 4 4 0 0 0 0 0 1,939 411 2,172,423 159 484 rio.public.temp0000284964 4 0 0 0 0 0 0 353 23 24,511 0 0 brasilia.pg_catalog.pg_depend 3 3 0 0 0 0 0 856 225 425,261 14 154 brasilia.public.temp0000235836 3 0 0 0 0 0 0 720 18 45,871 0 0 rio.public.temp0000284904 3 0 0 0 0 0 0 3,377 14 201,379 0 0 brasilia.pg_catalog.pg_statistic 3 3 0 0 0 0 0 4,061 564 2,422,797 346 2,958 contagem.public.temp0000226583 3 0 0 0 0 0 0 212 17 15,258 0 0 brasilia.public.temp0000235826 2 0 0 0 0 0 0 249 11 16,915 0 0 brasilia.public.temp0000235752 2 0 0 0 0 0 0 478 244 393,360 0 0 brasilia.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 304 68 314,141 34 84 contagem.public.nf_entrada 2 2 0 0 0 0 0 136 41 105,290 5 87 contagem.public.temp0000226589 2 0 0 0 0 0 0 206 12 14,048 0 0 rio.public.temp0000284920 2 0 0 0 0 0 0 98 9 7,252 0 0 rio.public.temp0000284916 1 0 0 0 0 0 0 108 6 7,294 0 0 brasilia.public.temp0000235756 1 0 0 0 0 0 0 239 6 15,234 0 0 brasilia.public.temp0000235766 1 0 0 0 0 0 0 240 6 15,292 0 0 brasilia.public.nf_entrada_arquivo_erros 1 0 0 0 0 0 0 393 135 382,099 122 7,046 brasilia.public.temp0000235828 1 0 0 0 0 0 0 240 238 376,588 0 0 rio.auditor.auditor_2026_07 1 0 0 0 0 0 0 67,391 32,868 43,073,648 17,163 358,797 brasilia.public.nf_entrada_itens 1 1 0 0 0 0 0 6,483 5,898 23,751,713 9 775 rio.public.giga_testes 1 1 0 0 0 0 0 27,824 21,946 71,275,645 306 5,243 rio.public.temp0000284966 1 0 0 0 0 0 0 102 6 6,964 0 0 brasilia.public.temp0000235700 1 0 0 0 0 0 0 239 6 15,236 0 0 rio.public.temp0000284986 1 0 0 0 0 0 0 4 3 774 0 0 rio.public.temp0000284970 1 0 0 0 0 0 0 102 6 6,964 0 0 contagem.public.temp0000226575 1 0 0 0 0 0 0 103 6 7,049 0 0 brasilia.auditor.auditor_2026_07 1 0 0 0 0 0 0 19,034 11,923 15,278,951 3,578 63,724 brasilia.public.notas_fiscais 1 0 0 0 0 0 0 19 15 26,253 4 273 brasilia.public.nf_entrada 1 1 0 0 0 0 0 332 193 302,829 3 5 brasilia.public.lote_caixas 1 0 0 0 0 0 0 44 34 67,298 12 640 rio.public.temp0000284918 1 0 0 0 0 0 0 94 6 6,478 0 0 brasilia.public.temp0000235834 1 0 0 0 0 0 0 8 6 3,482 0 0 rio.public.equipamentos_referencia 1 0 0 0 0 0 0 235 195 660,241 20 3,700 brasilia.pg_catalog.pg_shdepend 1 1 0 0 0 0 0 155 51 106,891 6 9 rio.public.temp0000284912 1 0 0 0 0 0 0 8 5 1,319 0 0 contagem.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,153 6 156,712 0 0 rio.public.temp0000284962 1 0 0 0 0 0 0 8 5 1,319 0 0 brasilia.public.temp0000235796 1 0 0 0 0 0 0 240 239 377,471 0 0 rio.public.temp0000284976 1 0 0 0 0 0 0 8 5 1,346 0 0 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 137 2 10,705 0 0 rio.public.temp0000284316 1 0 0 0 0 0 0 1,642 4 97,481 0 0 brasilia.public.temp0000235710 1 0 0 0 0 0 0 241 6 15,406 0 0 brasilia.public.temp0000235822 1 0 0 0 0 0 0 240 6 15,292 0 0 rio.public.temp0000284984 1 0 0 0 0 0 0 4 3 774 0 0 Total 440 211 0 0 0 0 0 275,590 96,367 204,522,360 23,522 459,645 Vacuum throughput per table
Key values
- public.giga_testes (16.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.public.temp0000284888 0 0 1.62 rio.pg_catalog.pg_attribute 0 0 2.53 rio.pg_catalog.pg_class 0 0 0.74 contagem.public.usuarios 0 0 0 rio.pg_catalog.pg_type 0 0 0.28 contagem.pg_catalog.pg_attribute 0 0 1.42 rio.public.temp0000284968 0 0 0.79 rio.public.temp0000284988 0 0 0.37 brasilia.pg_catalog.pg_attribute 0 0 1.21 rio.pg_catalog.pg_index 0 0 0.1 rio.public.temp0000284750 0 0 0.17 contagem.pg_catalog.pg_class 0 0 0.3 rio.pg_catalog.pg_depend 0 0 0.84 rio.public.temp0000284896 0 0 0.56 contagem.pg_catalog.pg_type 0 0 0.14 rio.public.temp0000284664 0 0 0.17 brasilia.pg_catalog.pg_class 0 0 0.27 rio.public.usuarios 0 0 0.01 rio.pg_catalog.pg_statistic 0 0 1.42 template1.pg_catalog.pg_shdepend 0 0 0.26 rio.public.temp0000284798 0 0 0.07 rio.public.temp0000284762 0 0 0.11 rio.public.temp0000284910 0 0 0.22 brasilia.pg_catalog.pg_type 0 0 0.11 rio.public.temp0000284950 0 0 0.33 contagem.public.temp0000226579 0 0 0.09 brasilia.pg_catalog.pg_index 0 0 0.05 contagem.pg_catalog.pg_depend 0 0 0.28 contagem.pg_catalog.pg_index 0 0 0.25 rio.public.tmp_drill_0175 0 0 0 rio.pg_toast.pg_toast_2619 0 0 0.22 rio.public.temp0000284964 0 0 0.09 brasilia.pg_catalog.pg_depend 0 0 0.15 brasilia.public.temp0000235836 0 0 0.06 rio.public.temp0000284904 0 0 0.11 brasilia.pg_catalog.pg_statistic 0 0 0.39 contagem.public.temp0000226583 0 0 0.04 brasilia.public.temp0000235826 0 0 0.05 brasilia.public.temp0000235752 0 0 0.05 brasilia.pg_toast.pg_toast_2619 0 0 0.03 contagem.public.nf_entrada 0 0 0.04 contagem.public.temp0000226589 0 0 0.03 rio.public.temp0000284920 0 0 0.06 rio.public.temp0000284916 0 0 0.02 brasilia.public.temp0000235756 0 0 0.03 brasilia.public.temp0000235766 0 0 0.03 brasilia.public.nf_entrada_arquivo_erros 0 0 0.07 brasilia.public.temp0000235828 0 0 0.02 rio.auditor.auditor_2026_07 0 0 11.05 brasilia.public.nf_entrada_itens 0 0 3.2 rio.public.giga_testes 0 0 16.11 rio.public.temp0000284966 0 0 0.02 brasilia.public.temp0000235700 0 0 0.03 rio.public.temp0000284986 0 0 0 rio.public.temp0000284970 0 0 0.01 contagem.public.temp0000226575 0 0 0.02 brasilia.auditor.auditor_2026_07 0 0 4.33 brasilia.public.notas_fiscais 0 0 0.01 brasilia.public.nf_entrada 0 0 0.07 brasilia.public.lote_caixas 0 0 0.01 rio.public.temp0000284918 0 0 0.02 brasilia.public.temp0000235834 0 0 0.02 rio.public.equipamentos_referencia 0 0 0.07 brasilia.pg_catalog.pg_shdepend 0 0 0.03 rio.public.temp0000284912 0 0 0.03 contagem.pg_catalog.pg_statistic 0 0 0.04 rio.public.temp0000284962 0 0 0.01 brasilia.public.temp0000235796 0 0 0.03 rio.public.temp0000284976 0 0 0.01 contagem.pg_toast.pg_toast_2619 0 0 0 rio.public.temp0000284316 0 0 0.05 brasilia.public.temp0000235710 0 0 0.02 brasilia.public.temp0000235822 0 0 0.02 rio.public.temp0000284984 0 0 0 Total 0 0 51.41 Tuples removed per table
Key values
- pg_catalog.pg_attribute (131021) Main table with removed tuples on database rio
- 337378 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 35 34 131,021 859,688 29,596 1 21,340 brasilia.pg_catalog.pg_attribute 13 13 64,546 302,487 416 102 7,750 contagem.pg_catalog.pg_attribute 18 16 57,901 428,263 22,164 77 9,979 rio.pg_catalog.pg_statistic 8 8 13,994 67,091 436 0 10,288 rio.pg_catalog.pg_depend 10 10 10,744 194,003 3,841 15 1,840 rio.pg_catalog.pg_type 19 18 6,915 45,071 2,000 9 1,386 brasilia.pg_catalog.pg_statistic 3 3 6,122 24,610 63 0 3,216 template1.pg_catalog.pg_shdepend 7 7 5,087 95,074 14 0 805 brasilia.auditor.auditor_2026_07 1 0 4,923 1,437,713 0 0 64,892 contagem.pg_catalog.pg_statistic 1 1 4,385 7,274 0 0 1,011 rio.pg_catalog.pg_class 22 20 4,235 81,990 5,969 45 2,733 contagem.pg_catalog.pg_depend 5 5 3,714 96,184 2,324 0 890 contagem.pg_catalog.pg_class 10 8 3,091 38,584 5,371 10 1,258 brasilia.pg_catalog.pg_type 7 7 2,800 15,687 4 9 468 contagem.pg_catalog.pg_type 10 8 2,708 24,672 2,158 10 669 rio.pg_catalog.pg_index 12 10 2,276 24,040 1,078 0 635 rio.public.tmp_drill_0175 4 4 1,530 2,013 0 0 56 contagem.public.usuarios 22 0 1,393 506 0 0 44 rio.public.giga_testes 1 1 1,363 3,707,297 0 0 99,413 brasilia.pg_catalog.pg_index 5 5 1,351 9,445 4 4 258 brasilia.pg_catalog.pg_depend 3 3 1,237 54,883 19 0 535 rio.pg_toast.pg_toast_2619 4 4 1,218 2,371 13 0 1,172 contagem.pg_catalog.pg_index 5 5 1,114 9,495 0 0 257 brasilia.pg_catalog.pg_shdepend 1 1 1,011 13,621 0 0 115 brasilia.pg_catalog.pg_class 8 8 699 27,403 28 38 904 contagem.public.nf_entrada 2 2 532 3,015 0 0 138 rio.public.usuarios 8 5 426 4,958 886 0 136 rio.auditor.auditor_2026_07 1 0 416 6,486,875 0 0 303,082 brasilia.pg_toast.pg_toast_2619 2 2 182 277 0 24 94 brasilia.public.notas_fiscais 1 0 126 92,276 0 0 544 brasilia.public.nf_entrada 1 1 115 3,068 0 0 152 contagem.pg_toast.pg_toast_2619 1 1 112 117 0 0 56 brasilia.public.lote_caixas 1 0 71 124,416 0 0 1,024 brasilia.public.nf_entrada_itens 1 1 20 1,639,734 0 0 17,044 rio.public.temp0000284888 55 0 0 522,423 0 1,339 36,421 rio.public.temp0000284916 1 0 0 4,468 0 28 100 brasilia.public.temp0000235756 1 0 0 3,085 0 25 231 brasilia.public.temp0000235766 1 0 0 3,086 0 24 232 brasilia.public.nf_entrada_arquivo_erros 1 0 0 1,653,186 0 0 29,608 brasilia.public.temp0000235828 1 0 0 3,089 0 24 232 contagem.public.temp0000226579 5 0 0 6,179 0 168 472 brasilia.public.temp0000235826 2 0 0 6,174 0 48 464 rio.public.temp0000284966 1 0 0 1,792 0 34 94 brasilia.public.temp0000235700 1 0 0 3,085 0 25 231 rio.public.temp0000284986 1 0 0 5,577 0 0 128 brasilia.public.temp0000235752 2 0 0 6,170 0 50 462 rio.public.temp0000284970 1 0 0 1,792 0 34 94 brasilia.public.temp0000235836 3 0 0 9,271 0 72 696 contagem.public.temp0000226575 1 0 0 1,235 0 34 94 rio.public.temp0000284904 3 0 0 47,840 0 42 3,414 rio.public.temp0000284750 11 0 0 27,875 0 281 615 rio.public.temp0000284918 1 0 0 1,668 0 42 86 rio.public.temp0000284896 10 0 0 230,864 0 0 16,640 rio.public.temp0000284798 7 0 0 19,886 0 59 453 rio.public.temp0000284762 7 0 0 29,040 0 177 655 brasilia.public.temp0000235834 1 0 0 3,089 0 24 232 rio.public.temp0000284950 6 0 0 117,226 0 34 8,414 rio.public.equipamentos_referencia 1 0 0 5,170,045 0 0 27,949 rio.public.temp0000284968 15 0 0 346,465 0 0 24,960 rio.public.temp0000284964 4 0 0 19,664 0 71 441 rio.public.temp0000284912 1 0 0 1,667 0 42 86 rio.public.temp0000284962 1 0 0 4,554 0 26 102 rio.public.temp0000284664 9 0 0 42,161 0 204 948 contagem.public.temp0000226583 3 0 0 3,704 0 102 282 brasilia.public.temp0000235796 1 0 0 3,087 0 24 232 rio.public.temp0000284976 1 0 0 1,887 0 32 96 rio.public.temp0000284910 7 0 0 77,833 0 92 5,284 contagem.public.temp0000226589 2 0 0 2,475 0 66 190 rio.public.temp0000284316 1 0 0 23,088 0 0 1,664 rio.public.temp0000284988 14 0 0 98,078 0 536 4,776 brasilia.public.temp0000235710 1 0 0 3,085 0 25 231 brasilia.public.temp0000235822 1 0 0 3,087 0 24 232 rio.public.temp0000284920 2 0 0 24,756 0 42 1,750 rio.public.temp0000284984 1 0 0 5,678 0 0 128 Total 440 211 337,378 24,463,615 76,384 4,194 723,603 Pages removed per table
Key values
- public.temp0000284888 (1339) Main table with removed pages on database rio
- 4194 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.public.temp0000284888 55 0 0 1339 rio.public.temp0000284988 14 0 0 536 rio.public.temp0000284750 11 0 0 281 rio.public.temp0000284664 9 0 0 204 rio.public.temp0000284762 7 0 0 177 contagem.public.temp0000226579 5 0 0 168 brasilia.pg_catalog.pg_attribute 13 13 64546 102 contagem.public.temp0000226583 3 0 0 102 rio.public.temp0000284910 7 0 0 92 contagem.pg_catalog.pg_attribute 18 16 57901 77 brasilia.public.temp0000235836 3 0 0 72 rio.public.temp0000284964 4 0 0 71 contagem.public.temp0000226589 2 0 0 66 rio.public.temp0000284798 7 0 0 59 brasilia.public.temp0000235752 2 0 0 50 brasilia.public.temp0000235826 2 0 0 48 rio.pg_catalog.pg_class 22 20 4235 45 rio.public.temp0000284904 3 0 0 42 rio.public.temp0000284918 1 0 0 42 rio.public.temp0000284912 1 0 0 42 rio.public.temp0000284920 2 0 0 42 brasilia.pg_catalog.pg_class 8 8 699 38 rio.public.temp0000284966 1 0 0 34 rio.public.temp0000284970 1 0 0 34 contagem.public.temp0000226575 1 0 0 34 rio.public.temp0000284950 6 0 0 34 rio.public.temp0000284976 1 0 0 32 rio.public.temp0000284916 1 0 0 28 rio.public.temp0000284962 1 0 0 26 brasilia.public.temp0000235756 1 0 0 25 brasilia.public.temp0000235700 1 0 0 25 brasilia.public.temp0000235710 1 0 0 25 brasilia.public.temp0000235766 1 0 0 24 brasilia.public.temp0000235828 1 0 0 24 brasilia.public.temp0000235834 1 0 0 24 brasilia.pg_toast.pg_toast_2619 2 2 182 24 brasilia.public.temp0000235796 1 0 0 24 brasilia.public.temp0000235822 1 0 0 24 rio.pg_catalog.pg_depend 10 10 10744 15 contagem.pg_catalog.pg_class 10 8 3091 10 contagem.pg_catalog.pg_type 10 8 2708 10 rio.pg_catalog.pg_type 19 18 6915 9 brasilia.pg_catalog.pg_type 7 7 2800 9 brasilia.pg_catalog.pg_index 5 5 1351 4 rio.pg_catalog.pg_attribute 35 34 131021 1 rio.pg_catalog.pg_index 12 10 2276 0 contagem.public.usuarios 22 0 1393 0 brasilia.public.nf_entrada_arquivo_erros 1 0 0 0 rio.auditor.auditor_2026_07 1 0 416 0 brasilia.public.nf_entrada_itens 1 1 20 0 rio.public.giga_testes 1 1 1363 0 brasilia.pg_catalog.pg_depend 3 3 1237 0 rio.public.temp0000284986 1 0 0 0 rio.public.tmp_drill_0175 4 4 1530 0 rio.public.usuarios 8 5 426 0 brasilia.auditor.auditor_2026_07 1 0 4923 0 rio.pg_toast.pg_toast_2619 4 4 1218 0 brasilia.public.notas_fiscais 1 0 126 0 brasilia.public.nf_entrada 1 1 115 0 brasilia.public.lote_caixas 1 0 71 0 template1.pg_catalog.pg_shdepend 7 7 5087 0 rio.public.temp0000284896 10 0 0 0 rio.public.equipamentos_referencia 1 0 0 0 brasilia.pg_catalog.pg_shdepend 1 1 1011 0 rio.public.temp0000284968 15 0 0 0 rio.pg_catalog.pg_statistic 8 8 13994 0 contagem.pg_catalog.pg_statistic 1 1 4385 0 brasilia.pg_catalog.pg_statistic 3 3 6122 0 contagem.public.nf_entrada 2 2 532 0 contagem.pg_toast.pg_toast_2619 1 1 112 0 rio.public.temp0000284316 1 0 0 0 contagem.pg_catalog.pg_depend 5 5 3714 0 rio.public.temp0000284984 1 0 0 0 contagem.pg_catalog.pg_index 5 5 1114 0 Total 440 211 337,378 4,194 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jul 09 00 0 0 01 0 1 02 0 0 03 0 0 04 0 3 05 7 6 06 0 1 07 21 45 08 46 118 09 30 82 10 34 87 11 47 114 12 19 28 13 66 104 14 64 115 15 34 80 16 29 80 17 29 65 18 12 16 19 0 0 20 0 0 21 2 4 22 0 0 23 0 0 - 16.11 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- AccessExclusiveLock Main Lock Type
- 4 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 1 1m13s 1m13s 1m13s 1m13s select * from rs_nf_entrada_exclui (?);-
SELECT * FROM RS_NF_ENTRADA_EXCLUI (01512);
Date: 2026-07-09 13:24:01 Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
SELECT * FROM RS_NF_ENTRADA_EXCLUI (01513);
Date: 2026-07-09 13:13:54 Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
2 1 5s569ms 5s569ms 5s569ms 5s569ms call rs_giga_triagem (?);-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-09 03:05:31 Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-09 00:05:27 Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-09 09:35:18 Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-09.log
3 1 1s1ms 1s1ms 1s1ms 1s1ms drop table if exists temp0000284896;-
DROP TABLE IF EXISTS temp0000284896;
Date: 2026-07-09 11:40:45 Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
DROP TABLE IF EXISTS temp0000284896;
Date: 2026-07-09 11:40:45 Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
4 1 1s 1s 1s 1s drop table if exists temp0000284968;-
DROP TABLE IF EXISTS temp0000284968;
Date: 2026-07-09 14:35:47 Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
DROP TABLE IF EXISTS temp0000284968;
Date: 2026-07-09 14:35:47 Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
Queries that waited the most
Rank Wait time Query 1 1m13s SELECT * FROM RS_NF_ENTRADA_EXCLUI (01513);[ Date: 2026-07-09 13:13:54 - Database: contagem - User: intelifix - Remote: [local] - Application: [unknown] ]
2 5s569ms CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-07-09 09:35:17 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 1s1ms DROP TABLE IF EXISTS temp0000284896;[ Date: 2026-07-09 11:40:45 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
4 1s DROP TABLE IF EXISTS temp0000284968;[ Date: 2026-07-09 14:35:47 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
-
Queries
Queries by type
Key values
- 4,582 Total read queries
- 1,418 Total write queries
Queries by database
Key values
- rio Main database
- 4,262 Requests
- 6h12m41s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 13,432 Requests
User Request type Count Duration etiquetas Total 93 18s582ms select 93 18s582ms intelifix Total 13,432 17h45m6s copy to 647 1h38m40s ddl 2,579 1h56m58s others 922 1h22m select 9,284 12h47m27s lenon Total 224 2m8s select 224 2m8s Duration by user
Key values
- 17h45m6s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 93 18s582ms select 93 18s582ms intelifix Total 13,432 17h45m6s copy to 647 1h38m40s ddl 2,579 1h56m58s others 922 1h22m select 9,284 12h47m27s lenon Total 224 2m8s select 224 2m8s Queries by host
Key values
- [local] Main host
- 13,748 Requests
- 17h47m33s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 5,476 Requests
- 4h33m15s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-07-09 20:56:02 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 3,363 100-500ms duration
Slowest individual queries
Rank Duration Query 1 9m24s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-09 09:14:26 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 9m19s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-09 10:14:21 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 9m15s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-09 15:14:17 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 9m14s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-09 07:14:16 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 9m13s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-09 11:14:14 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 9m4s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-09 14:14:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 8m52s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-09 17:13:54 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 8m43s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-09 16:13:44 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 8m36s analyze verbose;[ Date: 2026-07-09 05:08:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 8m17s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-09 08:13:18 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 8m3s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-09 13:13:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 7m52s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-09 12:12:53 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 7m17s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-09 20:12:19 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 6m14s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-09 18:11:15 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 6m1s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026838, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-07-09 09:35:17 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
16 6m SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-09 21:11:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 5m59s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-09 22:11:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 5m39s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-09 19:10:41 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 5m34s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026870, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-07-09 14:30:13 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
20 5m27s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026834, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-07-09 08:49:11 - 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 2h17m2s 48 1s538ms 9m24s 2m51s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 09 07 3 9m51s 3m17s 08 3 8m53s 2m57s 09 3 10m7s 3m22s 10 3 9m49s 3m16s 11 3 9m52s 3m17s 12 3 8m28s 2m49s 13 3 8m35s 2m51s 14 3 9m41s 3m13s 15 3 10m 3m20s 16 3 9m23s 3m7s 17 3 9m34s 3m11s 18 3 6m31s 2m10s 19 3 5m56s 1m58s 20 3 7m43s 2m34s 21 3 6m17s 2m5s 22 3 6m15s 2m5s [ User: intelifix - Total duration: 2h17m2s - Times executed: 48 ]
[ Application: psql - Total duration: 2h17m2s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-09 09:14:26 Duration: 9m24s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-09 10:14:21 Duration: 9m19s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-09 15:14:17 Duration: 9m15s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-09.log
2 1h21m46s 48 217ms 5m13s 1m42s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 09 07 3 5m10s 1m43s 08 3 5m36s 1m52s 09 3 6m5s 2m1s 10 3 5m5s 1m41s 11 3 5m54s 1m58s 12 3 5m19s 1m46s 13 3 5m10s 1m43s 14 3 5m46s 1m55s 15 3 6m22s 2m7s 16 3 5m34s 1m51s 17 3 5m19s 1m46s 18 3 3m55s 1m18s 19 3 3m54s 1m18s 20 3 4m31s 1m30s 21 3 4m4s 1m21s 22 3 3m55s 1m18s [ User: intelifix - Total duration: 1h21m46s - Times executed: 48 ]
[ Application: psql - Total duration: 1h21m46s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-09 15:21:21 Duration: 5m13s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-09 11:20:45 Duration: 4m52s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-09 09:21:08 Duration: 4m51s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-09.log
3 1h19m15s 351 151ms 6m1s 13s548ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 09 07 22 10m1s 27s332ms 08 23 5m57s 15s523ms 09 26 6m14s 14s408ms 10 30 6m10s 12s333ms 11 28 5m30s 11s820ms 12 20 5m39s 16s997ms 13 22 48s377ms 2s198ms 14 63 13m14s 12s616ms 15 50 14m4s 16s885ms 16 34 10m14s 18s80ms 17 29 1m1s 2s122ms 18 4 17s936ms 4s484ms [ User: intelifix - Total duration: 1h19m15s - Times executed: 351 ]
[ Application: [unknown] - Total duration: 1h19m15s - Times executed: 351 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026838, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-09 09:35:17 Duration: 6m1s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026870, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-09 14:30:13 Duration: 5m34s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026834, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-09 08:49:11 Duration: 5m27s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
4 18m25s 1,214 150ms 6s223ms 910ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 09 07 26 32s514ms 1s250ms 08 199 2m8s 645ms 09 169 2m4s 737ms 10 102 1m38s 964ms 11 84 1m17s 916ms 12 43 43s385ms 1s8ms 13 71 1m14s 1s49ms 14 160 2m37s 983ms 15 134 2m37s 1s173ms 16 140 2m21s 1s9ms 17 86 1m10s 820ms [ User: intelifix - Total duration: 18m25s - Times executed: 1214 ]
[ Application: [unknown] - Total duration: 18m25s - Times executed: 1214 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (264405, 508, '921131106202,582FF796888F,186A81D5750B,D0CF0EFDA417,4C195DD4B845,186A81D5990E,D833B7A3C420,582FF78CEA97,44D454A25BAD,E4C0E2401053,E4C0E2985103,6CBAB8EA0237,CC5830E1FAFF,64FD96566486,5447CC49DA57,64FD9655B02A,94988F30F955,5CFA2580B63F,5CFA25AD196D,6CBAB8EA85BD,841EA3694AA9,44D454AB99A9,5CFA25AD5AFF,841EA375968E,D0CF0EFE071A,C4EB42A15D14,E4C0E23FC4DB,38A6591B3A98,94988F30E4EF', '',0155,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-09 15:47:24 Duration: 6s223ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (264406, 433, 'CP2242LV6RZ,B85E71C53320$CP2048LVACC,484BD4968DEC$CP2526LV677,3C82C0929734$CP2534LV4LK,3C82C092AB0C$CP2234LV84Y,4075C3B821FC$CP2528LVA1F,F8D2AC4C5B1C$CP2534LV05D,3C82C090968C$CP2531LV2MP,3C82C0900654$CP2248LV87B,B85E71E3D6F4$CP2208LV4VR,3C82C0C94CD4$CP2204LV3JG,1C9D726A8964$CP2208LV1AL,3C82C0C765E0$CP2233LV8A8,4075C3B4A66C$CP2142LVDDU,ECA81FFAB024$CP2241LV5PJ,B85E71C7946C$CP2305LV004,B85E71EBF0C8$CP2111LV4AG,08A7C04D07FC$CP2425LV6ER,C4509CAF2474$CP2205LV1MN,3C82C06AC46C$CP2226LV9W0,80DAC2CF1C68$CP2530LV0BJ,F8D2ACC9BF78$CP2522LV1BH,B85E710DED54$CP2243LV5UV,B85E71CE6120$CP2239LVKV0,B85E71BDFEE8$CP2143LV1LA,ECA81FFCC90C$CP2141LV3Y8,ECA81FF93C9C$CP2522LV3MT,B85E710DE084$CP2534LV1LN,3C82C090530C$CP2142LV5B5,ECA81FF939CC$CP2233LVCNV,4075C3B30EC4$CP2249LV7Z4,B85E71E1D070$CP2234LV41W,4075C3B3FDC0$CP2120LV1W2,08A7C06B9714$CP2532LV04R,3C82C08FF9D4$CP2241LV3FD,B85E71C39E84$CP2233LVBGD,4075C3B406F8$CP2239LV1R4,4075C3C1748C$CP2134LV7C9,ECA81F23C324$CP2435LV5T5,C4509CF0D5BC', '',0185,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-09 10:37:06 Duration: 5s595ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (45255, 418, '835071911003567,241659676772,241727261214,241593437479,241729513555,241668196268,230048482745,241695575663,241664783141,241656685762,241676749000,241664778392,241621027882,241646441834,241680366064,241727278790,241654106464,241665695665,241668204249,241654536787,230048480523,241608666979,241676731726,241680355457,241659758396,241598155774,241593211521,241695585765,241701347079,241680419100,241668198187,241664790112,241695623951,241680295575,241656679498,241654543960,241676731120,241620831725,241664801931,241732175363,241680404149,241607203840,241727051923,241713718286,241688926271,241594948604,241594962949,241652015172,241680523454,241654354850', '',0321,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-09 08:23:28 Duration: 5s33ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
5 15m28s 72 9s947ms 41s263ms 12s899ms create table temp0000284888 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 09 07 13 2m32s 11s728ms 08 12 2m35s 12s926ms 09 6 1m16s 12s818ms 10 5 1m1s 12s305ms 11 6 1m16s 12s744ms 12 4 45s835ms 11s458ms 14 15 3m11s 12s786ms 15 8 2m8s 16s118ms 16 3 39s685ms 13s228ms [ User: intelifix - Total duration: 15m28s - Times executed: 72 ]
[ Application: [unknown] - Total duration: 15m28s - Times executed: 72 ]
-
CREATE TABLE temp0000284888 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-09 15:41:57 Duration: 41s263ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
CREATE TABLE temp0000284888 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-09 11:49:10 Duration: 15s311ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
CREATE TABLE temp0000284888 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-09 09:27:12 Duration: 14s694ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
6 14m40s 3 2m15s 8m36s 4m53s analyze verbose;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 09 05 3 14m40s 4m53s [ User: intelifix - Total duration: 14m40s - Times executed: 3 ]
[ Application: psql - Total duration: 14m40s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-07-09 05:08:38 Duration: 8m36s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
analyze verbose;
Date: 2026-07-09 05:12:26 Duration: 3m48s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
analyze verbose;
Date: 2026-07-09 05:14:41 Duration: 2m15s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-09.log
7 12m45s 118 1s667ms 24s459ms 6s490ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 09 07 3 9s70ms 3s23ms 08 7 1m13s 10s509ms 09 7 29s493ms 4s213ms 10 8 57s984ms 7s248ms 11 17 1m17s 4s587ms 12 2 5s761ms 2s880ms 13 14 2m2s 8s761ms 14 12 1m31s 7s614ms 15 15 1m20s 5s383ms 16 21 2m17s 6s543ms 17 12 1m19s 6s654ms [ User: intelifix - Total duration: 12m45s - Times executed: 118 ]
[ Application: [unknown] - Total duration: 12m45s - Times executed: 118 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-09', 0175, '', '', 0, 6, '2026-07-01');
Date: 2026-07-09 13:05:48 Duration: 24s459ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-09', 0175, '', '', 0, 6, '2026-07-01');
Date: 2026-07-09 10:04:02 Duration: 20s358ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-09', 0395, '', '', 0, 6, '2026-07-01');
Date: 2026-07-09 08:05:45 Duration: 20s95ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
8 12m39s 273 157ms 14s561ms 2s781ms call rs_giga_triagem (?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 09 00 11 38s715ms 3s519ms 01 12 30s585ms 2s548ms 02 12 30s870ms 2s572ms 03 12 38s657ms 3s221ms 04 12 31s243ms 2s603ms 05 12 32s168ms 2s680ms 06 12 33s776ms 2s814ms 07 12 36s134ms 3s11ms 08 11 34s247ms 3s113ms 09 12 43s52ms 3s587ms 10 12 35s816ms 2s984ms 11 12 35s379ms 2s948ms 12 12 37s399ms 3s116ms 13 12 34s669ms 2s889ms 14 12 38s439ms 3s203ms 15 12 36s263ms 3s21ms 16 12 32s202ms 2s683ms 17 12 25s853ms 2s154ms 18 12 24s59ms 2s4ms 19 12 26s299ms 2s191ms 20 11 31s416ms 2s856ms 21 12 27s107ms 2s258ms 22 12 24s955ms 2s79ms [ User: intelifix - Total duration: 12m39s - Times executed: 273 ]
[ Application: psql - Total duration: 12m39s - Times executed: 273 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-09 03:05:31 Duration: 14s561ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-09 00:05:27 Duration: 13s988ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-09 09:35:18 Duration: 11s641ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-09.log
9 9m11s 1,004 151ms 5s782ms 549ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 09 07 31 17s930ms 578ms 08 120 59s640ms 497ms 09 166 1m23s 505ms 10 144 1m10s 487ms 11 208 2m25s 699ms 12 9 6s3ms 667ms 13 79 42s617ms 539ms 14 71 37s760ms 531ms 15 136 1m6s 485ms 16 28 16s7ms 571ms 17 12 6s38ms 503ms [ User: intelifix - Total duration: 9m11s - Times executed: 1004 ]
[ Application: [unknown] - Total duration: 9m11s - Times executed: 1004 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "104675", "modelo" : "295", "itens" : "230054275274,230053099514,229988791824,229988525153,230054094549,230027387677,230030355072,230009719500,229989520818,230033608082,229967069513,229989099205,230026283743,230054093135,229960310111,230032406282,230014160316,229976660618,230014382739", "usuario" : "414", "caixa" : "1227257", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-09 11:17:25 Duration: 5s782ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "242688", "modelo" : "131", "itens" : "229720034057,229724215879,229724134760,216946246072,216946426774,229723331214,216904090208,216904172236,229722431115,229721618802,216888410406,216888688187,216887686586,216896401029,216886397279", "usuario" : "414", "caixa" : "2901413", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-09 11:00:09 Duration: 4s40ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "230007", "modelo" : "320", "itens" : "241667960208,241709744263,241704174662,241601509704,241709222439,241595261519,241599553756,241620905873,241706587377,241629456786,241708395152,241713983846,241679326782,241616745366,241618235556,241609249517,241671935466,241694012638,241651184148,241679167193,241635859813,241668185257,241635624459,241666434660,241653840828,241672652742,241693191133,241607814663,241622810931,241701337078,241617565962,241698554753,241703553838,241708263748,241617931128,241660360712,241630877070,241604382948,241672839404,241661186482,241617927086,241669618999,241672824756,241616171315,241622032942", "usuario" : "414", "caixa" : "2757970", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-09 11:39:38 Duration: 2s831ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
10 8m55s 13 555ms 2m3s 41s213ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel (?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 09 11 1 2m3s 2m3s 13 5 6m27s 1m17s 15 1 5s53ms 5s53ms 17 3 4s972ms 1s657ms 18 3 15s180ms 5s60ms [ User: intelifix - Total duration: 8m55s - Times executed: 13 ]
[ Application: psql - Total duration: 8m55s - Times executed: 13 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 406); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01511);
Date: 2026-07-09 11:43:38 Duration: 2m3s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
SELECT RS_SETGLOBAL ('USUARIO', 406); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01514);
Date: 2026-07-09 13:26:19 Duration: 1m54s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
SELECT RS_SETGLOBAL ('USUARIO', 406); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01512);
Date: 2026-07-09 13:13:10 Duration: 1m51s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-09.log
11 7m36s 164 165ms 12s552ms 2s782ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 09 00 5 18s518ms 3s703ms 01 5 8s466ms 1s693ms 02 5 7s696ms 1s539ms 03 5 10s214ms 2s42ms 04 5 9s598ms 1s919ms 05 5 9s587ms 1s917ms 06 2 3s325ms 1s662ms 07 12 33s687ms 2s807ms 08 12 47s418ms 3s951ms 09 12 46s965ms 3s913ms 10 12 37s922ms 3s160ms 11 12 34s640ms 2s886ms 12 12 37s184ms 3s98ms 13 8 10s609ms 1s326ms 14 12 37s822ms 3s151ms 15 12 41s558ms 3s463ms 16 11 31s704ms 2s882ms 17 7 4s586ms 655ms 21 4 14s867ms 3s716ms 22 6 9s997ms 1s666ms [ User: intelifix - Total duration: 7m36s - Times executed: 164 ]
[ Application: psql - Total duration: 7m36s - Times executed: 164 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-09 00:05:13 Duration: 12s552ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-09 12:35:11 Duration: 9s888ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-09 09:55:10 Duration: 8s435ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-09.log
12 5m50s 25 10s49ms 38s692ms 14s31ms create table temp0000284968 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 09 13 9 2m28s 16s463ms 14 16 3m22s 12s662ms [ User: intelifix - Total duration: 5m50s - Times executed: 25 ]
[ Application: [unknown] - Total duration: 5m50s - Times executed: 25 ]
-
CREATE TABLE temp0000284968 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-09 13:35:51 Duration: 38s692ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
CREATE TABLE temp0000284968 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-09 13:42:44 Duration: 14s855ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
CREATE TABLE temp0000284968 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-09 13:50:58 Duration: 14s715ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
13 4m36s 55 3s205ms 13s963ms 5s33ms create table temp0000284888 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 09 07 8 39s926ms 4s990ms 08 26 1m59s 4s589ms 09 5 24s364ms 4s872ms 11 4 28s845ms 7s211ms 12 4 17s474ms 4s368ms 14 2 10s21ms 5s10ms 16 6 36s878ms 6s146ms [ User: intelifix - Total duration: 4m36s - Times executed: 55 ]
[ Application: [unknown] - Total duration: 4m36s - Times executed: 55 ]
-
CREATE TABLE temp0000284888 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"04-07-2026", "ate" :"09-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-09 07:03:38 Duration: 13s963ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
CREATE TABLE temp0000284888 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"04-07-2026", "ate" :"09-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-09 11:29:19 Duration: 12s914ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
CREATE TABLE temp0000284888 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"04-07-2026", "ate" :"09-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-09 16:16:08 Duration: 12s301ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
14 3m50s 16 11s821ms 35s385ms 14s412ms create table temp0000284896 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 09 07 1 35s385ms 35s385ms 09 3 41s238ms 13s746ms 11 6 1m18s 13s117ms 12 5 1m2s 12s500ms 16 1 12s758ms 12s758ms [ User: intelifix - Total duration: 3m50s - Times executed: 16 ]
[ Application: [unknown] - Total duration: 3m50s - Times executed: 16 ]
-
CREATE TABLE temp0000284896 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-09 07:12:45 Duration: 35s385ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
CREATE TABLE temp0000284896 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-09 11:40:28 Duration: 14s95ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
CREATE TABLE temp0000284896 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-09 09:08:51 Duration: 14s6ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
15 3m4s 3 5s172ms 1m34s 1m1s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 09 20 2 1m40s 50s45ms 23 1 1m24s 1m24s [ User: intelifix - Total duration: 3m4s - Times executed: 3 ]
[ Application: pg_dump - Total duration: 3m4s - Times executed: 3 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-09 20:09:07 Duration: 1m34s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-09 23:40:36 Duration: 1m24s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-09 20:11:01 Duration: 5s172ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-09.log
16 2m45s 12 12s310ms 16s203ms 13s801ms create table temp0000284910 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 09 09 2 29s342ms 14s671ms 10 10 2m16s 13s627ms [ User: intelifix - Total duration: 2m45s - Times executed: 12 ]
[ Application: [unknown] - Total duration: 2m45s - Times executed: 12 ]
-
CREATE TABLE temp0000284910 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-09 09:56:26 Duration: 16s203ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
CREATE TABLE temp0000284910 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-09 10:05:09 Duration: 15s261ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
CREATE TABLE temp0000284910 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-09 10:08:55 Duration: 14s921ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
17 2m36s 58 166ms 38s185ms 2s703ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 09 07 5 2s162ms 432ms 08 4 1s453ms 363ms 09 6 39s762ms 6s627ms 10 13 40s678ms 3s129ms 11 3 2s894ms 964ms 12 4 2s804ms 701ms 13 3 10s731ms 3s577ms 14 11 52s679ms 4s789ms 15 3 1s766ms 588ms 16 5 1s628ms 325ms 17 1 234ms 234ms [ User: intelifix - Total duration: 2m36s - Times executed: 58 ]
[ Application: psql - Total duration: 2m36s - Times executed: 58 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 508); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026836);
Date: 2026-07-09 09:08:28 Duration: 38s185ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
SELECT RS_SETGLOBAL ('USUARIO', 449); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026867);
Date: 2026-07-09 14:13:38 Duration: 28s923ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
SELECT RS_SETGLOBAL ('USUARIO', 449); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026852);
Date: 2026-07-09 10:46:06 Duration: 27s546ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-09.log
18 2m21s 2 6s650ms 2m15s 1m10s copy auditor.auditor_2026_06 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 09 23 2 2m21s 1m10s [ User: intelifix - Total duration: 2m21s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m21s - Times executed: 2 ]
-
COPY auditor.auditor_2026_06 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-07-09 23:16:00 Duration: 2m15s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
COPY auditor.auditor_2026_06 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-07-09 23:41:11 Duration: 6s650ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-09.log
19 2m17s 283 154ms 2s295ms 485ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 09 14 281 2m16s 485ms 15 2 1s118ms 559ms [ User: intelifix - Total duration: 2m17s - Times executed: 283 ]
[ Application: [unknown] - Total duration: 2m17s - Times executed: 283 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"127627","seriais":"241775312727,241778789092,241767881026,241775299314,241775315757,241775314242,241762350621,241778647384,241768019400,241771639393,241771344461,241746452840,241775597176,241771499605,241768085972,241814480310,241775303254,241771282738,241778717795,241813301923,241765538900,241775598388,241747403247,241743234456,241771514556,241771226570,241775646070,241814229903,241814582542","usuario":"398","observacao":""}');
Date: 2026-07-09 14:39:51 Duration: 2s295ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"127627","seriais":"241678293640,241680292040,241713871636,241700808990,241731167071,241599503145,241717092040,241634791617,241634791213,241608786991,241608784971,241614618592,241673312133,241708701524,241604943238,241703156066,241619422126,241727560918,241668178892,241708700413,241708584565,241678299397,241599495366,241708601739,241601352641,241636042435,241663777980,241699056575,241692617888,241619458896,241717109314,241646509618,241708603052,241713840118,241708701726,241673320821,241727550816,241678188703,241727550412","usuario":"398","observacao":""}');
Date: 2026-07-09 14:37:20 Duration: 1s993ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"127627","seriais":"241637373642,241652158496,241708641215,241669903248,241628059108,241635396176,241638353648,241663210519,241667824661,241668139696,230049139610,241728864041,241680711329,241646735880,241675302226,241616317187,241616175456,241673775264,241628004355,241667830824,241636219196,241691615153,241665205965,241629516870,241649412034,241706863645,241652220928,241680702540,241654662232,241716381533,241631283149,241616214147,241660448093,241606030505,241704790312,241619567998,241783944658,241646723960,241628008395,241660447992","usuario":"398","observacao":""}');
Date: 2026-07-09 14:54:43 Duration: 1s943ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
20 2m8s 1 2m8s 2m8s 2m8s copy auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 09 23 1 2m8s 2m8s [ User: intelifix - Total duration: 2m8s - Times executed: 1 ]
[ Application: pg_dump - Total duration: 2m8s - Times executed: 1 ]
-
COPY auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-07-09 23:13:45 Duration: 2m8s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-09.log
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1,214 18m25s 150ms 6s223ms 910ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 09 07 26 32s514ms 1s250ms 08 199 2m8s 645ms 09 169 2m4s 737ms 10 102 1m38s 964ms 11 84 1m17s 916ms 12 43 43s385ms 1s8ms 13 71 1m14s 1s49ms 14 160 2m37s 983ms 15 134 2m37s 1s173ms 16 140 2m21s 1s9ms 17 86 1m10s 820ms [ User: intelifix - Total duration: 18m25s - Times executed: 1214 ]
[ Application: [unknown] - Total duration: 18m25s - Times executed: 1214 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (264405, 508, '921131106202,582FF796888F,186A81D5750B,D0CF0EFDA417,4C195DD4B845,186A81D5990E,D833B7A3C420,582FF78CEA97,44D454A25BAD,E4C0E2401053,E4C0E2985103,6CBAB8EA0237,CC5830E1FAFF,64FD96566486,5447CC49DA57,64FD9655B02A,94988F30F955,5CFA2580B63F,5CFA25AD196D,6CBAB8EA85BD,841EA3694AA9,44D454AB99A9,5CFA25AD5AFF,841EA375968E,D0CF0EFE071A,C4EB42A15D14,E4C0E23FC4DB,38A6591B3A98,94988F30E4EF', '',0155,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-09 15:47:24 Duration: 6s223ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (264406, 433, 'CP2242LV6RZ,B85E71C53320$CP2048LVACC,484BD4968DEC$CP2526LV677,3C82C0929734$CP2534LV4LK,3C82C092AB0C$CP2234LV84Y,4075C3B821FC$CP2528LVA1F,F8D2AC4C5B1C$CP2534LV05D,3C82C090968C$CP2531LV2MP,3C82C0900654$CP2248LV87B,B85E71E3D6F4$CP2208LV4VR,3C82C0C94CD4$CP2204LV3JG,1C9D726A8964$CP2208LV1AL,3C82C0C765E0$CP2233LV8A8,4075C3B4A66C$CP2142LVDDU,ECA81FFAB024$CP2241LV5PJ,B85E71C7946C$CP2305LV004,B85E71EBF0C8$CP2111LV4AG,08A7C04D07FC$CP2425LV6ER,C4509CAF2474$CP2205LV1MN,3C82C06AC46C$CP2226LV9W0,80DAC2CF1C68$CP2530LV0BJ,F8D2ACC9BF78$CP2522LV1BH,B85E710DED54$CP2243LV5UV,B85E71CE6120$CP2239LVKV0,B85E71BDFEE8$CP2143LV1LA,ECA81FFCC90C$CP2141LV3Y8,ECA81FF93C9C$CP2522LV3MT,B85E710DE084$CP2534LV1LN,3C82C090530C$CP2142LV5B5,ECA81FF939CC$CP2233LVCNV,4075C3B30EC4$CP2249LV7Z4,B85E71E1D070$CP2234LV41W,4075C3B3FDC0$CP2120LV1W2,08A7C06B9714$CP2532LV04R,3C82C08FF9D4$CP2241LV3FD,B85E71C39E84$CP2233LVBGD,4075C3B406F8$CP2239LV1R4,4075C3C1748C$CP2134LV7C9,ECA81F23C324$CP2435LV5T5,C4509CF0D5BC', '',0185,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-09 10:37:06 Duration: 5s595ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (45255, 418, '835071911003567,241659676772,241727261214,241593437479,241729513555,241668196268,230048482745,241695575663,241664783141,241656685762,241676749000,241664778392,241621027882,241646441834,241680366064,241727278790,241654106464,241665695665,241668204249,241654536787,230048480523,241608666979,241676731726,241680355457,241659758396,241598155774,241593211521,241695585765,241701347079,241680419100,241668198187,241664790112,241695623951,241680295575,241656679498,241654543960,241676731120,241620831725,241664801931,241732175363,241680404149,241607203840,241727051923,241713718286,241688926271,241594948604,241594962949,241652015172,241680523454,241654354850', '',0321,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-09 08:23:28 Duration: 5s33ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
2 1,004 9m11s 151ms 5s782ms 549ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 09 07 31 17s930ms 578ms 08 120 59s640ms 497ms 09 166 1m23s 505ms 10 144 1m10s 487ms 11 208 2m25s 699ms 12 9 6s3ms 667ms 13 79 42s617ms 539ms 14 71 37s760ms 531ms 15 136 1m6s 485ms 16 28 16s7ms 571ms 17 12 6s38ms 503ms [ User: intelifix - Total duration: 9m11s - Times executed: 1004 ]
[ Application: [unknown] - Total duration: 9m11s - Times executed: 1004 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "104675", "modelo" : "295", "itens" : "230054275274,230053099514,229988791824,229988525153,230054094549,230027387677,230030355072,230009719500,229989520818,230033608082,229967069513,229989099205,230026283743,230054093135,229960310111,230032406282,230014160316,229976660618,230014382739", "usuario" : "414", "caixa" : "1227257", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-09 11:17:25 Duration: 5s782ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "242688", "modelo" : "131", "itens" : "229720034057,229724215879,229724134760,216946246072,216946426774,229723331214,216904090208,216904172236,229722431115,229721618802,216888410406,216888688187,216887686586,216896401029,216886397279", "usuario" : "414", "caixa" : "2901413", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-09 11:00:09 Duration: 4s40ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "230007", "modelo" : "320", "itens" : "241667960208,241709744263,241704174662,241601509704,241709222439,241595261519,241599553756,241620905873,241706587377,241629456786,241708395152,241713983846,241679326782,241616745366,241618235556,241609249517,241671935466,241694012638,241651184148,241679167193,241635859813,241668185257,241635624459,241666434660,241653840828,241672652742,241693191133,241607814663,241622810931,241701337078,241617565962,241698554753,241703553838,241708263748,241617931128,241660360712,241630877070,241604382948,241672839404,241661186482,241617927086,241669618999,241672824756,241616171315,241622032942", "usuario" : "414", "caixa" : "2757970", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-09 11:39:38 Duration: 2s831ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
3 351 1h19m15s 151ms 6m1s 13s548ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 09 07 22 10m1s 27s332ms 08 23 5m57s 15s523ms 09 26 6m14s 14s408ms 10 30 6m10s 12s333ms 11 28 5m30s 11s820ms 12 20 5m39s 16s997ms 13 22 48s377ms 2s198ms 14 63 13m14s 12s616ms 15 50 14m4s 16s885ms 16 34 10m14s 18s80ms 17 29 1m1s 2s122ms 18 4 17s936ms 4s484ms [ User: intelifix - Total duration: 1h19m15s - Times executed: 351 ]
[ Application: [unknown] - Total duration: 1h19m15s - Times executed: 351 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026838, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-09 09:35:17 Duration: 6m1s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026870, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-09 14:30:13 Duration: 5m34s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026834, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-09 08:49:11 Duration: 5m27s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
4 283 2m17s 154ms 2s295ms 485ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 09 14 281 2m16s 485ms 15 2 1s118ms 559ms [ User: intelifix - Total duration: 2m17s - Times executed: 283 ]
[ Application: [unknown] - Total duration: 2m17s - Times executed: 283 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"127627","seriais":"241775312727,241778789092,241767881026,241775299314,241775315757,241775314242,241762350621,241778647384,241768019400,241771639393,241771344461,241746452840,241775597176,241771499605,241768085972,241814480310,241775303254,241771282738,241778717795,241813301923,241765538900,241775598388,241747403247,241743234456,241771514556,241771226570,241775646070,241814229903,241814582542","usuario":"398","observacao":""}');
Date: 2026-07-09 14:39:51 Duration: 2s295ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"127627","seriais":"241678293640,241680292040,241713871636,241700808990,241731167071,241599503145,241717092040,241634791617,241634791213,241608786991,241608784971,241614618592,241673312133,241708701524,241604943238,241703156066,241619422126,241727560918,241668178892,241708700413,241708584565,241678299397,241599495366,241708601739,241601352641,241636042435,241663777980,241699056575,241692617888,241619458896,241717109314,241646509618,241708603052,241713840118,241708701726,241673320821,241727550816,241678188703,241727550412","usuario":"398","observacao":""}');
Date: 2026-07-09 14:37:20 Duration: 1s993ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"127627","seriais":"241637373642,241652158496,241708641215,241669903248,241628059108,241635396176,241638353648,241663210519,241667824661,241668139696,230049139610,241728864041,241680711329,241646735880,241675302226,241616317187,241616175456,241673775264,241628004355,241667830824,241636219196,241691615153,241665205965,241629516870,241649412034,241706863645,241652220928,241680702540,241654662232,241716381533,241631283149,241616214147,241660448093,241606030505,241704790312,241619567998,241783944658,241646723960,241628008395,241660447992","usuario":"398","observacao":""}');
Date: 2026-07-09 14:54:43 Duration: 1s943ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
5 273 12m39s 157ms 14s561ms 2s781ms call rs_giga_triagem (?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 09 00 11 38s715ms 3s519ms 01 12 30s585ms 2s548ms 02 12 30s870ms 2s572ms 03 12 38s657ms 3s221ms 04 12 31s243ms 2s603ms 05 12 32s168ms 2s680ms 06 12 33s776ms 2s814ms 07 12 36s134ms 3s11ms 08 11 34s247ms 3s113ms 09 12 43s52ms 3s587ms 10 12 35s816ms 2s984ms 11 12 35s379ms 2s948ms 12 12 37s399ms 3s116ms 13 12 34s669ms 2s889ms 14 12 38s439ms 3s203ms 15 12 36s263ms 3s21ms 16 12 32s202ms 2s683ms 17 12 25s853ms 2s154ms 18 12 24s59ms 2s4ms 19 12 26s299ms 2s191ms 20 11 31s416ms 2s856ms 21 12 27s107ms 2s258ms 22 12 24s955ms 2s79ms [ User: intelifix - Total duration: 12m39s - Times executed: 273 ]
[ Application: psql - Total duration: 12m39s - Times executed: 273 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-09 03:05:31 Duration: 14s561ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-09 00:05:27 Duration: 13s988ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-09 09:35:18 Duration: 11s641ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-09.log
6 254 41s296ms 150ms 198ms 162ms select * from rs_modelos_lista (null, null) where mod_id = ?;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 09 01 1 155ms 155ms 05 3 471ms 157ms 07 6 984ms 164ms 08 22 3s578ms 162ms 09 50 8s252ms 165ms 10 19 3s93ms 162ms 11 49 7s888ms 160ms 12 2 348ms 174ms 13 19 3s125ms 164ms 14 26 4s152ms 159ms 15 34 5s556ms 163ms 16 12 1s928ms 160ms 17 11 1s760ms 160ms [ User: intelifix - Total duration: 41s296ms - Times executed: 254 ]
[ Application: [unknown] - Total duration: 41s296ms - Times executed: 254 ]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 0295;
Date: 2026-07-09 09:05:04 Duration: 198ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 039;
Date: 2026-07-09 09:22:09 Duration: 191ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 0156;
Date: 2026-07-09 11:28:05 Duration: 191ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
7 164 7m36s 165ms 12s552ms 2s782ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 09 00 5 18s518ms 3s703ms 01 5 8s466ms 1s693ms 02 5 7s696ms 1s539ms 03 5 10s214ms 2s42ms 04 5 9s598ms 1s919ms 05 5 9s587ms 1s917ms 06 2 3s325ms 1s662ms 07 12 33s687ms 2s807ms 08 12 47s418ms 3s951ms 09 12 46s965ms 3s913ms 10 12 37s922ms 3s160ms 11 12 34s640ms 2s886ms 12 12 37s184ms 3s98ms 13 8 10s609ms 1s326ms 14 12 37s822ms 3s151ms 15 12 41s558ms 3s463ms 16 11 31s704ms 2s882ms 17 7 4s586ms 655ms 21 4 14s867ms 3s716ms 22 6 9s997ms 1s666ms [ User: intelifix - Total duration: 7m36s - Times executed: 164 ]
[ Application: psql - Total duration: 7m36s - Times executed: 164 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-09 00:05:13 Duration: 12s552ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-09 12:35:11 Duration: 9s888ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-09 09:55:10 Duration: 8s435ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-09.log
8 137 25s407ms 150ms 382ms 185ms select * from rs_produtividade_horas_html (?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 09 01 1 153ms 153ms 05 1 186ms 186ms 09 3 531ms 177ms 10 3 532ms 177ms 11 14 2s373ms 169ms 12 6 1s145ms 190ms 13 23 4s88ms 177ms 14 22 3s856ms 175ms 15 28 5s240ms 187ms 16 27 5s394ms 199ms 17 9 1s903ms 211ms [ User: intelifix - Total duration: 25s407ms - Times executed: 137 ]
[ Application: [unknown] - Total duration: 25s407ms - Times executed: 137 ]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "432", "data-de" : "2026-07-09", "data-ate" : "2026-07-09", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 503 }');
Date: 2026-07-09 17:18:33 Duration: 382ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "432", "data-de" : "2026-07-09", "data-ate" : "2026-07-09", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 503 }');
Date: 2026-07-09 16:31:25 Duration: 346ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "432", "data-de" : "2026-07-09", "data-ate" : "2026-07-09", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 503 }');
Date: 2026-07-09 15:31:11 Duration: 336ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
9 118 12m45s 1s667ms 24s459ms 6s490ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 09 07 3 9s70ms 3s23ms 08 7 1m13s 10s509ms 09 7 29s493ms 4s213ms 10 8 57s984ms 7s248ms 11 17 1m17s 4s587ms 12 2 5s761ms 2s880ms 13 14 2m2s 8s761ms 14 12 1m31s 7s614ms 15 15 1m20s 5s383ms 16 21 2m17s 6s543ms 17 12 1m19s 6s654ms [ User: intelifix - Total duration: 12m45s - Times executed: 118 ]
[ Application: [unknown] - Total duration: 12m45s - Times executed: 118 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-09', 0175, '', '', 0, 6, '2026-07-01');
Date: 2026-07-09 13:05:48 Duration: 24s459ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-09', 0175, '', '', 0, 6, '2026-07-01');
Date: 2026-07-09 10:04:02 Duration: 20s358ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-09', 0395, '', '', 0, 6, '2026-07-01');
Date: 2026-07-09 08:05:45 Duration: 20s95ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
10 105 51s957ms 269ms 867ms 494ms 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 #10
Day Hour Count Duration Avg duration Jul 09 01 2 922ms 461ms 04 2 800ms 400ms 05 2 1s187ms 593ms 06 1 319ms 319ms 07 11 4s745ms 431ms 08 9 4s526ms 502ms 09 5 2s770ms 554ms 10 9 4s522ms 502ms 11 9 4s898ms 544ms 12 6 2s967ms 494ms 13 10 3s983ms 398ms 14 9 4s697ms 521ms 15 11 6s185ms 562ms 16 10 5s203ms 520ms 17 5 2s642ms 528ms 18 2 742ms 371ms 21 2 841ms 420ms [ User: lenon - Total duration: 51s957ms - Times executed: 105 ]
[ Application: [unknown] - Total duration: 51s957ms - Times executed: 105 ]
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-07-09 11:00:07 Duration: 867ms Database: brasilia User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-07-09 16:10:11 Duration: 784ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-07-09 09:33:06 Duration: 746ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-09.log
11 104 1m23s 166ms 6s979ms 803ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 09 07 17 9s383ms 551ms 09 2 2s80ms 1s40ms 10 14 11s697ms 835ms 11 6 3s870ms 645ms 13 2 2s811ms 1s405ms 14 24 17s588ms 732ms 15 15 18s123ms 1s208ms 16 18 15s687ms 871ms 17 6 2s286ms 381ms [ User: intelifix - Total duration: 1m23s - Times executed: 104 ]
[ Application: [unknown] - Total duration: 1m23s - Times executed: 104 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0127627) LIMIT 1;
Date: 2026-07-09 15:02:10 Duration: 6s979ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0127566) LIMIT 1;
Date: 2026-07-09 16:57:10 Duration: 2s640ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0127429) LIMIT 1;
Date: 2026-07-09 15:13:59 Duration: 2s528ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
12 99 1m 347ms 987ms 612ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 09 01 2 1s261ms 630ms 04 2 1s131ms 565ms 05 2 1s335ms 667ms 07 9 4s879ms 542ms 08 9 5s613ms 623ms 09 5 3s283ms 656ms 10 9 5s651ms 627ms 11 9 5s848ms 649ms 12 6 3s566ms 594ms 13 10 5s15ms 501ms 14 9 5s875ms 652ms 15 11 7s335ms 666ms 16 10 6s278ms 627ms 17 4 2s496ms 624ms 18 1 566ms 566ms 21 1 528ms 528ms [ User: intelifix - Total duration: 1m - Times executed: 99 ]
[ Application: [unknown] - Total duration: 1m - Times executed: 99 ]
-
select * from rs_menu_grants (428, 19, 1);
Date: 2026-07-09 11:00:07 Duration: 987ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
select * from rs_menu_grants (433, 18, 1);
Date: 2026-07-09 09:33:06 Duration: 903ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
select * from rs_menu_grants (99, 19, 1);
Date: 2026-07-09 16:10:11 Duration: 877ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
13 93 20s137ms 150ms 747ms 216ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 09 01 10 1s921ms 192ms 04 3 609ms 203ms 05 9 2s574ms 286ms 07 6 1s244ms 207ms 08 7 1s302ms 186ms 09 9 1s989ms 221ms 10 7 1s557ms 222ms 11 8 1s704ms 213ms 12 10 1s999ms 199ms 13 3 1s30ms 343ms 14 7 1s539ms 219ms 15 12 2s269ms 189ms 16 2 392ms 196ms [ User: intelifix - Total duration: 20s137ms - Times executed: 93 ]
[ Application: [unknown] - Total duration: 20s137ms - Times executed: 93 ]
-
SELECT * FROM RS_TRIAGEM (429, 5, '113', 3, '241714637175,241600854152,241708492738,241593319410,241704724951,241654387075,241661207898,241680322626,241700710823,241602709204,241664771120,241636122443,241709086566,241676742030,241620815662,241708019504,241711592244,241666257796,241666294848,241699863860,241691839192,241654397581,241714764158,241630117894,241731832951,241658636884,241661023234,241661211031,241661020305,241658548289,230048511738,241602663139,241707041418,241627865374,241728641012,241711202430,241649301518,241669676884,241716605976,241679502535,241635884563,241629351726,241658103645,241703915669,241656700714,241692670723,241659013947,241634747998,241670024146,241663099901,241680526282,241609905877,241664811629,241708811434,241707377185,241727962023,241731091734,241730481315,241639360021,241663627281,241617401020,241732041333', NULL, NULL, 0320, 00);
Date: 2026-07-09 05:08:56 Duration: 747ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
SELECT * FROM RS_TRIAGEM (357, 5, '113', 3, '840BBB943498,840BBB958674,840BBB95D79C,840BBB95ACE0,840BBB94065C,840BBB954C38,840BBB9586A0,840BBB95F450,840BBB94FB78,840BBB9586E0,840BBB94FC20,840BBB9406E4,840BBB95B31C,840BBB93B294,840BBB9433CC,840BBB9587A4,840BBB950D84,840BBB9435C8,840BBB944B64,840BBBD4C640,840BBB9526F8,840BBB9407B4,840BBB94305C,840BBB94FAB4,840BBB94F918,840BBB944C70,840BBB94CBAC,840BBB9434E8,840BBB95D640,840BBB947394,840BBBD4C5B0,840BBB95D6E8,840BBB944CC4', NULL, NULL, 0431, 00);
Date: 2026-07-09 13:39:22 Duration: 396ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
SELECT * FROM RS_TRIAGEM (385, 5, '113', 3, '840BBB947DDC,840BBB948014,840BBB9406A4,840BBB95F0A4,840BBB94FA50,840BBB940754,840BBB95D750,840BBB958CE4,840BBB947378,840BBB95ABF4,840BBB95F49C,840BBB957EF0,840BBB95F42C,840BBB943164,840BBB952430,840BBB9477A0,840BBB938B9C,840BBB947F70,840BBB94322C,840BBB93B198,840BBB947FFC,840BBB946EDC,840BBB958008,840BBB958C74,840BBB950F48,840BBB9580F0,840BBB95854C,840BBB958094,840BBB938A14,840BBB947E3C,840BBB95AB80,840BBB947F08', NULL, NULL, 0431, 00);
Date: 2026-07-09 13:26:29 Duration: 370ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
14 85 34s176ms 217ms 768ms 402ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 09 07 2 586ms 293ms 08 8 3s282ms 410ms 09 3 1s339ms 446ms 10 6 2s745ms 457ms 11 9 3s581ms 397ms 12 9 3s237ms 359ms 13 6 2s677ms 446ms 14 12 4s774ms 397ms 15 11 4s600ms 418ms 16 5 2s161ms 432ms 17 9 3s620ms 402ms 18 5 1s569ms 313ms [ User: intelifix - Total duration: 34s176ms - Times executed: 85 ]
[ Application: [unknown] - Total duration: 34s176ms - Times executed: 85 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 029;
Date: 2026-07-09 13:49:17 Duration: 768ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 054;
Date: 2026-07-09 10:07:28 Duration: 657ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-07-09 15:39:46 Duration: 647ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
15 72 15m28s 9s947ms 41s263ms 12s899ms create table temp0000284888 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 09 07 13 2m32s 11s728ms 08 12 2m35s 12s926ms 09 6 1m16s 12s818ms 10 5 1m1s 12s305ms 11 6 1m16s 12s744ms 12 4 45s835ms 11s458ms 14 15 3m11s 12s786ms 15 8 2m8s 16s118ms 16 3 39s685ms 13s228ms [ User: intelifix - Total duration: 15m28s - Times executed: 72 ]
[ Application: [unknown] - Total duration: 15m28s - Times executed: 72 ]
-
CREATE TABLE temp0000284888 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-09 15:41:57 Duration: 41s263ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
CREATE TABLE temp0000284888 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-09 11:49:10 Duration: 15s311ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
CREATE TABLE temp0000284888 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-09 09:27:12 Duration: 14s694ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
16 65 26s616ms 155ms 1s519ms 409ms select * from rs_baixa_executa (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 09 07 3 537ms 179ms 08 15 6s187ms 412ms 09 6 2s403ms 400ms 10 3 1s325ms 441ms 11 3 791ms 263ms 12 2 388ms 194ms 13 2 809ms 404ms 14 7 3s509ms 501ms 15 6 3s5ms 500ms 16 15 6s929ms 461ms 17 3 728ms 242ms [ User: intelifix - Total duration: 26s616ms - Times executed: 65 ]
[ Application: [unknown] - Total duration: 26s616ms - Times executed: 65 ]
-
SELECT * FROM RS_BAIXA_EXECUTA (310, 5, 7, 6, 'A0FF7026D934,6C55E8C38EAC,A0FF7028408C,A0FF7087E0AC,484BD47B8144,484BD480A914,F4C11476F22C,A0FF702BFE7C,A0FF70267DE4,484BD4804254,6C55E8CD0F4C,5C7D7D6C109C,889E68DAF0E4,484BD4901784,6C55E8C9F6BC,6C55E869404C,484BD4917E64,5C7D7D6ED4B4,484BD48E40CC,484BD499B5C4,A0FF708A1D64,F4C11471E964,6C55E8CBCE4C,5C7D7D5BB4B4,A0FF70D1A7F4,5C7D7D5AC034,484BD47F74A4,A0FF70D25EF4,F4C1147B99EC,484BD4999CD4', '95;1', 'DEFAULT', 09, 0154, '','', '', 00);
Date: 2026-07-09 16:22:51 Duration: 1s519ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
SELECT * FROM RS_BAIXA_EXECUTA (358, 11, 2, 6, '689E29BD8265,38914851606D,843C9922C41B,D89A0D84A1D3,14CA56D01B5B,6C11BA655737,3CF9F0A94DF4,843C9932D6D1,5872C98F1B0F,F4E84F81D4F0,5872C98B54CD,4896D953D6F2,48D68236D120,48D68232000E,4896D9567356,D89A0DA87C27,843C992259EF,843C99329ACB,C4EBFF90356A', '138;1', 'DEFAULT', 09, 0323, '','', '', 00);
Date: 2026-07-09 08:22:58 Duration: 998ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
SELECT * FROM RS_BAIXA_EXECUTA (310, 5, 7, 6, '8C444FC172F8,C85D38018494,C85D38064B41,C85D388C4F4E,C85D38664D94,C85D38CCE5C3,C85D38EA2412,D86C5A5DE760,C85D38A2B4DD,C85D38A76C5D,D86C5A030DE7,C85D38D5CD2A', '77;1', 'DEFAULT', 09, 0151, '','', '', 00);
Date: 2026-07-09 16:10:10 Duration: 937ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
17 63 14s384ms 155ms 567ms 228ms create table temp0000235780 as select * from rs_lotes_saida_lista (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 09 14 10 2s496ms 249ms 15 17 3s614ms 212ms 16 6 1s333ms 222ms 17 30 6s939ms 231ms [ User: intelifix - Total duration: 14s384ms - Times executed: 63 ]
[ Application: [unknown] - Total duration: 14s384ms - Times executed: 63 ]
-
CREATE TABLE temp0000235780 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "7", "cliente" : "0", "nf" : "", "data-de" : "04-07-2026", "data-ate" : "09-07-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-07-09 14:23:27 Duration: 567ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
CREATE TABLE temp0000235780 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "7", "cliente" : "0", "nf" : "", "data-de" : "09-07-2026", "data-ate" : "09-07-2026", "grupo" : "0", "status" : "-1", "tipo" : "N", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-07-09 17:14:58 Duration: 353ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
CREATE TABLE temp0000235780 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "7", "cliente" : "0", "nf" : "", "data-de" : "09-07-2026", "data-ate" : "09-07-2026", "grupo" : "0", "status" : "-1", "tipo" : "N", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-07-09 17:31:14 Duration: 303ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
18 62 20s959ms 152ms 550ms 338ms select * from rs_lotes_saida_lista (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 09 10 17 6s619ms 389ms 11 43 14s30ms 326ms 13 1 156ms 156ms 14 1 152ms 152ms [ User: intelifix - Total duration: 20s959ms - Times executed: 62 ]
[ Application: [unknown] - Total duration: 20s959ms - Times executed: 62 ]
-
SELECT * FROM RS_LOTES_SAIDA_LISTA (242688);
Date: 2026-07-09 10:59:13 Duration: 550ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
SELECT * FROM RS_LOTES_SAIDA_LISTA (242688);
Date: 2026-07-09 10:58:23 Duration: 532ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
SELECT * FROM RS_LOTES_SAIDA_LISTA (243786);
Date: 2026-07-09 11:14:10 Duration: 522ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
19 58 2m36s 166ms 38s185ms 2s703ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 09 07 5 2s162ms 432ms 08 4 1s453ms 363ms 09 6 39s762ms 6s627ms 10 13 40s678ms 3s129ms 11 3 2s894ms 964ms 12 4 2s804ms 701ms 13 3 10s731ms 3s577ms 14 11 52s679ms 4s789ms 15 3 1s766ms 588ms 16 5 1s628ms 325ms 17 1 234ms 234ms [ User: intelifix - Total duration: 2m36s - Times executed: 58 ]
[ Application: psql - Total duration: 2m36s - Times executed: 58 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 508); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026836);
Date: 2026-07-09 09:08:28 Duration: 38s185ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
SELECT RS_SETGLOBAL ('USUARIO', 449); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026867);
Date: 2026-07-09 14:13:38 Duration: 28s923ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
SELECT RS_SETGLOBAL ('USUARIO', 449); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026852);
Date: 2026-07-09 10:46:06 Duration: 27s546ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-09.log
20 57 19s962ms 153ms 3s805ms 350ms create table temp0000284914 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 09 08 14 6s627ms 473ms 09 10 2s703ms 270ms 10 12 3s929ms 327ms 11 21 6s701ms 319ms [ User: intelifix - Total duration: 19s962ms - Times executed: 57 ]
[ Application: [unknown] - Total duration: 19s962ms - Times executed: 57 ]
-
CREATE TABLE temp0000284914 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"04-07-2026", "ate" :"09-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-09 08:09:04 Duration: 3s805ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
CREATE TABLE temp0000284914 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"04-07-2026", "ate" :"09-07-2026", "nota-fiscal":"81475", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-09 10:35:00 Duration: 459ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
CREATE TABLE temp0000284914 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"04-07-2026", "ate" :"09-07-2026", "nota-fiscal":"81475", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-09 11:50:10 Duration: 456ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 2m15s 8m36s 4m53s 3 14m40s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 09 05 3 14m40s 4m53s [ User: intelifix - Total duration: 14m40s - Times executed: 3 ]
[ Application: psql - Total duration: 14m40s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-07-09 05:08:38 Duration: 8m36s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
analyze verbose;
Date: 2026-07-09 05:12:26 Duration: 3m48s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
analyze verbose;
Date: 2026-07-09 05:14:41 Duration: 2m15s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-09.log
2 1s538ms 9m24s 2m51s 48 2h17m2s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 09 07 3 9m51s 3m17s 08 3 8m53s 2m57s 09 3 10m7s 3m22s 10 3 9m49s 3m16s 11 3 9m52s 3m17s 12 3 8m28s 2m49s 13 3 8m35s 2m51s 14 3 9m41s 3m13s 15 3 10m 3m20s 16 3 9m23s 3m7s 17 3 9m34s 3m11s 18 3 6m31s 2m10s 19 3 5m56s 1m58s 20 3 7m43s 2m34s 21 3 6m17s 2m5s 22 3 6m15s 2m5s [ User: intelifix - Total duration: 2h17m2s - Times executed: 48 ]
[ Application: psql - Total duration: 2h17m2s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-09 09:14:26 Duration: 9m24s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-09 10:14:21 Duration: 9m19s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-09 15:14:17 Duration: 9m15s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-09.log
3 2m8s 2m8s 2m8s 1 2m8s copy auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 09 23 1 2m8s 2m8s [ User: intelifix - Total duration: 2m8s - Times executed: 1 ]
[ Application: pg_dump - Total duration: 2m8s - Times executed: 1 ]
-
COPY auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-07-09 23:13:45 Duration: 2m8s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-09.log
4 217ms 5m13s 1m42s 48 1h21m46s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 09 07 3 5m10s 1m43s 08 3 5m36s 1m52s 09 3 6m5s 2m1s 10 3 5m5s 1m41s 11 3 5m54s 1m58s 12 3 5m19s 1m46s 13 3 5m10s 1m43s 14 3 5m46s 1m55s 15 3 6m22s 2m7s 16 3 5m34s 1m51s 17 3 5m19s 1m46s 18 3 3m55s 1m18s 19 3 3m54s 1m18s 20 3 4m31s 1m30s 21 3 4m4s 1m21s 22 3 3m55s 1m18s [ User: intelifix - Total duration: 1h21m46s - Times executed: 48 ]
[ Application: psql - Total duration: 1h21m46s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-09 15:21:21 Duration: 5m13s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-09 11:20:45 Duration: 4m52s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-09 09:21:08 Duration: 4m51s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-09.log
5 6s650ms 2m15s 1m10s 2 2m21s copy auditor.auditor_2026_06 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 09 23 2 2m21s 1m10s [ User: intelifix - Total duration: 2m21s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m21s - Times executed: 2 ]
-
COPY auditor.auditor_2026_06 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-07-09 23:16:00 Duration: 2m15s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
COPY auditor.auditor_2026_06 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-07-09 23:41:11 Duration: 6s650ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-09.log
6 5s172ms 1m34s 1m1s 3 3m4s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 09 20 2 1m40s 50s45ms 23 1 1m24s 1m24s [ User: intelifix - Total duration: 3m4s - Times executed: 3 ]
[ Application: pg_dump - Total duration: 3m4s - Times executed: 3 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-09 20:09:07 Duration: 1m34s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-09 23:40:36 Duration: 1m24s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-09 20:11:01 Duration: 5s172ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-09.log
7 555ms 2m3s 41s213ms 13 8m55s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel (?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 09 11 1 2m3s 2m3s 13 5 6m27s 1m17s 15 1 5s53ms 5s53ms 17 3 4s972ms 1s657ms 18 3 15s180ms 5s60ms [ User: intelifix - Total duration: 8m55s - Times executed: 13 ]
[ Application: psql - Total duration: 8m55s - Times executed: 13 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 406); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01511);
Date: 2026-07-09 11:43:38 Duration: 2m3s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
SELECT RS_SETGLOBAL ('USUARIO', 406); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01514);
Date: 2026-07-09 13:26:19 Duration: 1m54s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
SELECT RS_SETGLOBAL ('USUARIO', 406); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01512);
Date: 2026-07-09 13:13:10 Duration: 1m51s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-09.log
8 11s821ms 35s385ms 14s412ms 16 3m50s create table temp0000284896 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 09 07 1 35s385ms 35s385ms 09 3 41s238ms 13s746ms 11 6 1m18s 13s117ms 12 5 1m2s 12s500ms 16 1 12s758ms 12s758ms [ User: intelifix - Total duration: 3m50s - Times executed: 16 ]
[ Application: [unknown] - Total duration: 3m50s - Times executed: 16 ]
-
CREATE TABLE temp0000284896 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-09 07:12:45 Duration: 35s385ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
CREATE TABLE temp0000284896 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-09 11:40:28 Duration: 14s95ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
CREATE TABLE temp0000284896 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-09 09:08:51 Duration: 14s6ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
9 10s49ms 38s692ms 14s31ms 25 5m50s create table temp0000284968 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 09 13 9 2m28s 16s463ms 14 16 3m22s 12s662ms [ User: intelifix - Total duration: 5m50s - Times executed: 25 ]
[ Application: [unknown] - Total duration: 5m50s - Times executed: 25 ]
-
CREATE TABLE temp0000284968 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-09 13:35:51 Duration: 38s692ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
CREATE TABLE temp0000284968 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-09 13:42:44 Duration: 14s855ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
CREATE TABLE temp0000284968 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-09 13:50:58 Duration: 14s715ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
10 12s310ms 16s203ms 13s801ms 12 2m45s create table temp0000284910 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 09 09 2 29s342ms 14s671ms 10 10 2m16s 13s627ms [ User: intelifix - Total duration: 2m45s - Times executed: 12 ]
[ Application: [unknown] - Total duration: 2m45s - Times executed: 12 ]
-
CREATE TABLE temp0000284910 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-09 09:56:26 Duration: 16s203ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
CREATE TABLE temp0000284910 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-09 10:05:09 Duration: 15s261ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
CREATE TABLE temp0000284910 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-09 10:08:55 Duration: 14s921ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
11 151ms 6m1s 13s548ms 351 1h19m15s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 09 07 22 10m1s 27s332ms 08 23 5m57s 15s523ms 09 26 6m14s 14s408ms 10 30 6m10s 12s333ms 11 28 5m30s 11s820ms 12 20 5m39s 16s997ms 13 22 48s377ms 2s198ms 14 63 13m14s 12s616ms 15 50 14m4s 16s885ms 16 34 10m14s 18s80ms 17 29 1m1s 2s122ms 18 4 17s936ms 4s484ms [ User: intelifix - Total duration: 1h19m15s - Times executed: 351 ]
[ Application: [unknown] - Total duration: 1h19m15s - Times executed: 351 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026838, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-09 09:35:17 Duration: 6m1s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026870, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-09 14:30:13 Duration: 5m34s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026834, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-09 08:49:11 Duration: 5m27s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
12 9s947ms 41s263ms 12s899ms 72 15m28s create table temp0000284888 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 09 07 13 2m32s 11s728ms 08 12 2m35s 12s926ms 09 6 1m16s 12s818ms 10 5 1m1s 12s305ms 11 6 1m16s 12s744ms 12 4 45s835ms 11s458ms 14 15 3m11s 12s786ms 15 8 2m8s 16s118ms 16 3 39s685ms 13s228ms [ User: intelifix - Total duration: 15m28s - Times executed: 72 ]
[ Application: [unknown] - Total duration: 15m28s - Times executed: 72 ]
-
CREATE TABLE temp0000284888 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-09 15:41:57 Duration: 41s263ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
CREATE TABLE temp0000284888 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-09 11:49:10 Duration: 15s311ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
CREATE TABLE temp0000284888 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-09 09:27:12 Duration: 14s694ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
13 1s667ms 24s459ms 6s490ms 118 12m45s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 09 07 3 9s70ms 3s23ms 08 7 1m13s 10s509ms 09 7 29s493ms 4s213ms 10 8 57s984ms 7s248ms 11 17 1m17s 4s587ms 12 2 5s761ms 2s880ms 13 14 2m2s 8s761ms 14 12 1m31s 7s614ms 15 15 1m20s 5s383ms 16 21 2m17s 6s543ms 17 12 1m19s 6s654ms [ User: intelifix - Total duration: 12m45s - Times executed: 118 ]
[ Application: [unknown] - Total duration: 12m45s - Times executed: 118 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-09', 0175, '', '', 0, 6, '2026-07-01');
Date: 2026-07-09 13:05:48 Duration: 24s459ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-09', 0175, '', '', 0, 6, '2026-07-01');
Date: 2026-07-09 10:04:02 Duration: 20s358ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-09', 0395, '', '', 0, 6, '2026-07-01');
Date: 2026-07-09 08:05:45 Duration: 20s95ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
14 3s205ms 13s963ms 5s33ms 55 4m36s create table temp0000284888 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 09 07 8 39s926ms 4s990ms 08 26 1m59s 4s589ms 09 5 24s364ms 4s872ms 11 4 28s845ms 7s211ms 12 4 17s474ms 4s368ms 14 2 10s21ms 5s10ms 16 6 36s878ms 6s146ms [ User: intelifix - Total duration: 4m36s - Times executed: 55 ]
[ Application: [unknown] - Total duration: 4m36s - Times executed: 55 ]
-
CREATE TABLE temp0000284888 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"04-07-2026", "ate" :"09-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-09 07:03:38 Duration: 13s963ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
CREATE TABLE temp0000284888 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"04-07-2026", "ate" :"09-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-09 11:29:19 Duration: 12s914ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
CREATE TABLE temp0000284888 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"04-07-2026", "ate" :"09-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-09 16:16:08 Duration: 12s301ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
15 165ms 12s552ms 2s782ms 164 7m36s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 09 00 5 18s518ms 3s703ms 01 5 8s466ms 1s693ms 02 5 7s696ms 1s539ms 03 5 10s214ms 2s42ms 04 5 9s598ms 1s919ms 05 5 9s587ms 1s917ms 06 2 3s325ms 1s662ms 07 12 33s687ms 2s807ms 08 12 47s418ms 3s951ms 09 12 46s965ms 3s913ms 10 12 37s922ms 3s160ms 11 12 34s640ms 2s886ms 12 12 37s184ms 3s98ms 13 8 10s609ms 1s326ms 14 12 37s822ms 3s151ms 15 12 41s558ms 3s463ms 16 11 31s704ms 2s882ms 17 7 4s586ms 655ms 21 4 14s867ms 3s716ms 22 6 9s997ms 1s666ms [ User: intelifix - Total duration: 7m36s - Times executed: 164 ]
[ Application: psql - Total duration: 7m36s - Times executed: 164 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-09 00:05:13 Duration: 12s552ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-09 12:35:11 Duration: 9s888ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-09 09:55:10 Duration: 8s435ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-09.log
16 157ms 14s561ms 2s781ms 273 12m39s call rs_giga_triagem (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 09 00 11 38s715ms 3s519ms 01 12 30s585ms 2s548ms 02 12 30s870ms 2s572ms 03 12 38s657ms 3s221ms 04 12 31s243ms 2s603ms 05 12 32s168ms 2s680ms 06 12 33s776ms 2s814ms 07 12 36s134ms 3s11ms 08 11 34s247ms 3s113ms 09 12 43s52ms 3s587ms 10 12 35s816ms 2s984ms 11 12 35s379ms 2s948ms 12 12 37s399ms 3s116ms 13 12 34s669ms 2s889ms 14 12 38s439ms 3s203ms 15 12 36s263ms 3s21ms 16 12 32s202ms 2s683ms 17 12 25s853ms 2s154ms 18 12 24s59ms 2s4ms 19 12 26s299ms 2s191ms 20 11 31s416ms 2s856ms 21 12 27s107ms 2s258ms 22 12 24s955ms 2s79ms [ User: intelifix - Total duration: 12m39s - Times executed: 273 ]
[ Application: psql - Total duration: 12m39s - Times executed: 273 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-09 03:05:31 Duration: 14s561ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-09 00:05:27 Duration: 13s988ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-09 09:35:18 Duration: 11s641ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-09.log
17 166ms 38s185ms 2s703ms 58 2m36s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 09 07 5 2s162ms 432ms 08 4 1s453ms 363ms 09 6 39s762ms 6s627ms 10 13 40s678ms 3s129ms 11 3 2s894ms 964ms 12 4 2s804ms 701ms 13 3 10s731ms 3s577ms 14 11 52s679ms 4s789ms 15 3 1s766ms 588ms 16 5 1s628ms 325ms 17 1 234ms 234ms [ User: intelifix - Total duration: 2m36s - Times executed: 58 ]
[ Application: psql - Total duration: 2m36s - Times executed: 58 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 508); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026836);
Date: 2026-07-09 09:08:28 Duration: 38s185ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
SELECT RS_SETGLOBAL ('USUARIO', 449); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026867);
Date: 2026-07-09 14:13:38 Duration: 28s923ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
SELECT RS_SETGLOBAL ('USUARIO', 449); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026852);
Date: 2026-07-09 10:46:06 Duration: 27s546ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-09.log
18 150ms 6s223ms 910ms 1,214 18m25s select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 09 07 26 32s514ms 1s250ms 08 199 2m8s 645ms 09 169 2m4s 737ms 10 102 1m38s 964ms 11 84 1m17s 916ms 12 43 43s385ms 1s8ms 13 71 1m14s 1s49ms 14 160 2m37s 983ms 15 134 2m37s 1s173ms 16 140 2m21s 1s9ms 17 86 1m10s 820ms [ User: intelifix - Total duration: 18m25s - Times executed: 1214 ]
[ Application: [unknown] - Total duration: 18m25s - Times executed: 1214 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (264405, 508, '921131106202,582FF796888F,186A81D5750B,D0CF0EFDA417,4C195DD4B845,186A81D5990E,D833B7A3C420,582FF78CEA97,44D454A25BAD,E4C0E2401053,E4C0E2985103,6CBAB8EA0237,CC5830E1FAFF,64FD96566486,5447CC49DA57,64FD9655B02A,94988F30F955,5CFA2580B63F,5CFA25AD196D,6CBAB8EA85BD,841EA3694AA9,44D454AB99A9,5CFA25AD5AFF,841EA375968E,D0CF0EFE071A,C4EB42A15D14,E4C0E23FC4DB,38A6591B3A98,94988F30E4EF', '',0155,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-09 15:47:24 Duration: 6s223ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (264406, 433, 'CP2242LV6RZ,B85E71C53320$CP2048LVACC,484BD4968DEC$CP2526LV677,3C82C0929734$CP2534LV4LK,3C82C092AB0C$CP2234LV84Y,4075C3B821FC$CP2528LVA1F,F8D2AC4C5B1C$CP2534LV05D,3C82C090968C$CP2531LV2MP,3C82C0900654$CP2248LV87B,B85E71E3D6F4$CP2208LV4VR,3C82C0C94CD4$CP2204LV3JG,1C9D726A8964$CP2208LV1AL,3C82C0C765E0$CP2233LV8A8,4075C3B4A66C$CP2142LVDDU,ECA81FFAB024$CP2241LV5PJ,B85E71C7946C$CP2305LV004,B85E71EBF0C8$CP2111LV4AG,08A7C04D07FC$CP2425LV6ER,C4509CAF2474$CP2205LV1MN,3C82C06AC46C$CP2226LV9W0,80DAC2CF1C68$CP2530LV0BJ,F8D2ACC9BF78$CP2522LV1BH,B85E710DED54$CP2243LV5UV,B85E71CE6120$CP2239LVKV0,B85E71BDFEE8$CP2143LV1LA,ECA81FFCC90C$CP2141LV3Y8,ECA81FF93C9C$CP2522LV3MT,B85E710DE084$CP2534LV1LN,3C82C090530C$CP2142LV5B5,ECA81FF939CC$CP2233LVCNV,4075C3B30EC4$CP2249LV7Z4,B85E71E1D070$CP2234LV41W,4075C3B3FDC0$CP2120LV1W2,08A7C06B9714$CP2532LV04R,3C82C08FF9D4$CP2241LV3FD,B85E71C39E84$CP2233LVBGD,4075C3B406F8$CP2239LV1R4,4075C3C1748C$CP2134LV7C9,ECA81F23C324$CP2435LV5T5,C4509CF0D5BC', '',0185,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-09 10:37:06 Duration: 5s595ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (45255, 418, '835071911003567,241659676772,241727261214,241593437479,241729513555,241668196268,230048482745,241695575663,241664783141,241656685762,241676749000,241664778392,241621027882,241646441834,241680366064,241727278790,241654106464,241665695665,241668204249,241654536787,230048480523,241608666979,241676731726,241680355457,241659758396,241598155774,241593211521,241695585765,241701347079,241680419100,241668198187,241664790112,241695623951,241680295575,241656679498,241654543960,241676731120,241620831725,241664801931,241732175363,241680404149,241607203840,241727051923,241713718286,241688926271,241594948604,241594962949,241652015172,241680523454,241654354850', '',0321,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-09 08:23:28 Duration: 5s33ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
19 166ms 6s979ms 803ms 104 1m23s select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 09 07 17 9s383ms 551ms 09 2 2s80ms 1s40ms 10 14 11s697ms 835ms 11 6 3s870ms 645ms 13 2 2s811ms 1s405ms 14 24 17s588ms 732ms 15 15 18s123ms 1s208ms 16 18 15s687ms 871ms 17 6 2s286ms 381ms [ User: intelifix - Total duration: 1m23s - Times executed: 104 ]
[ Application: [unknown] - Total duration: 1m23s - Times executed: 104 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0127627) LIMIT 1;
Date: 2026-07-09 15:02:10 Duration: 6s979ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0127566) LIMIT 1;
Date: 2026-07-09 16:57:10 Duration: 2s640ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0127429) LIMIT 1;
Date: 2026-07-09 15:13:59 Duration: 2s528ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
20 347ms 987ms 612ms 99 1m select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 09 01 2 1s261ms 630ms 04 2 1s131ms 565ms 05 2 1s335ms 667ms 07 9 4s879ms 542ms 08 9 5s613ms 623ms 09 5 3s283ms 656ms 10 9 5s651ms 627ms 11 9 5s848ms 649ms 12 6 3s566ms 594ms 13 10 5s15ms 501ms 14 9 5s875ms 652ms 15 11 7s335ms 666ms 16 10 6s278ms 627ms 17 4 2s496ms 624ms 18 1 566ms 566ms 21 1 528ms 528ms [ User: intelifix - Total duration: 1m - Times executed: 99 ]
[ Application: [unknown] - Total duration: 1m - Times executed: 99 ]
-
select * from rs_menu_grants (428, 19, 1);
Date: 2026-07-09 11:00:07 Duration: 987ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
select * from rs_menu_grants (433, 18, 1);
Date: 2026-07-09 09:33:06 Duration: 903ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
-
select * from rs_menu_grants (99, 19, 1);
Date: 2026-07-09 16:10:11 Duration: 877ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-09.log
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 9 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Jul 08 14 1 0ms 0ms 18 2 0ms 0ms 20 1 0ms 0ms 22 1 0ms 0ms Jul 09 18 1 0ms 0ms 19 1 0ms 0ms 20 1 0ms 0ms 21 1 0ms 0ms [ User: intelifix - Total duration: 9s671ms - Times executed: 9 ]
[ Application: psql - Total duration: 8s644ms - Times executed: 7 ]
[ Application: [unknown] - Total duration: 1s27ms - Times executed: 2 ]
-
;
Date: Duration: 0ms Database: postgres User: rio Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 19,272 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 16 FATAL entries
- 4593 ERROR entries
- 0 WARNING entries
- 6 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 4,425 Max number of times the same event was reported
- 4,615 Total events found
Rank Times reported Error 1 4,425 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Jul 09 00 60 01 59 02 59 03 54 04 59 05 59 06 60 07 279 08 501 09 515 10 395 11 340 12 236 13 164 14 312 15 489 16 300 17 136 18 60 19 59 20 60 21 60 22 59 23 50 - ERROR: prepared statement "_PLAN0000000029C44D80" does not exist
- ERROR: prepared statement "_PLAN0000000029C41B50" does not exist
- ERROR: prepared statement "_PLAN0000000029F750E0" does not exist
Statement: DEALLOCATE "_PLAN0000000029C44D80"
Date: 2026-07-09 00:00:03 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-09.log
Statement: DEALLOCATE "_PLAN0000000029C41B50"
Date: 2026-07-09 00:01:04 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-09.log
Statement: DEALLOCATE "_PLAN0000000029F750E0"
Date: 2026-07-09 00:02:05 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-09.log
2 46 ERROR: PermissionError: ... Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
Times Reported Most Frequent Error / Event #2
Day Hour Count Jul 09 00 2 01 2 02 2 03 2 04 2 05 2 06 2 07 2 08 2 09 2 10 2 11 2 12 2 13 2 14 2 15 2 16 2 17 2 18 2 19 2 20 2 21 2 22 2 - ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
- ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
- ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-07-09 00:05:01 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-09.log
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-07-09 00:35:01 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-09.log
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-07-09 01:05:01 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-09.log
3 45 ERROR: invalid input syntax for type json
Times Reported Most Frequent Error / Event #3
Day Hour Count Jul 09 08 3 09 3 10 3 11 3 12 3 13 3 14 3 15 3 16 3 17 3 18 3 19 3 20 3 21 3 22 3 - ERROR: invalid input syntax for type json
- ERROR: invalid input syntax for type json
- ERROR: invalid input syntax for type json
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936... PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-07-09 08:00:06 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-09.log
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936... PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-07-09 08:20:04 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-09.log
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936... PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-07-09 08:40:05 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-09.log
4 30 ERROR: trailing junk after numeric literal at or near "..."
Times Reported Most Frequent Error / Event #4
Day Hour Count Jul 09 08 9 09 3 10 3 11 3 14 5 15 3 17 4 - ERROR: trailing junk after numeric literal at or near "8F" at character 36
- ERROR: trailing junk after numeric literal at or near "8F" at character 36
- ERROR: trailing junk after numeric literal at or near "8F" at character 36
Statement: SELECT * FROM RS_ETIQUETA(DC-97-E6-8F-79-F0)
Date: 2026-07-09 08:28:25 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-09.log
Statement: SELECT * FROM RS_ETIQUETA(DC-97-E6-8F-79-F0)
Date: 2026-07-09 08:28:25 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-09.log
Statement: SELECT * FROM RS_ETIQUETA(DC-97-E6-8F-79-F0)
Date: 2026-07-09 08:28:25 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-09.log
5 26 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #5
Day Hour Count Jul 09 07 3 08 6 09 9 10 6 11 2 - ERROR: column "dc" does not exist at character 27
- ERROR: column "dc" does not exist at character 27
- ERROR: column "dc" does not exist at character 27
Statement: SELECT * FROM RS_ETIQUETA(DC-97-E6-A1-6E-79)
Date: 2026-07-09 07:14:13 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-09.log
Statement: SELECT * FROM RS_ETIQUETA(DC-97-E6-A1-6E-79)
Date: 2026-07-09 07:14:14 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-09.log
Statement: SELECT * FROM RS_ETIQUETA(DC-97-E6-A1-6E-79)
Date: 2026-07-09 07:14:14 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-09.log
6 10 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #6
Day Hour Count Jul 09 08 4 11 2 13 1 15 1 17 2 - ERROR: syntax error at or near "241597830008" at character 41
- ERROR: syntax error at or near "241597830008" at character 41
- ERROR: syntax error at or near ")" at character 34
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA(''241597830008');
Date: 2026-07-09 08:11:44 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-09.log
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA(''241597830008');
Date: 2026-07-09 08:11:50 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-09.log
Statement: select * from rs_caixa_qr(378393,)
Date: 2026-07-09 08:26:42 Database: brasilia Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-09.log
7 9 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #7
Day Hour Count Jul 09 03 9 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-07-09 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-09.log
Date: 2026-07-09 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-09.log
Date: 2026-07-09 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-09.log
8 4 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #8
Day Hour Count Jul 09 00 1 01 1 04 1 06 1 - FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-07-09 00:02:09 Database: testes Application: [unknown] User: lenon Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-09.log
Date: 2026-07-09 01:55:56 Database: jaboatao Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-09.log
Date: 2026-07-09 04:36:26 Database: jaboatao Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-09.log
9 4 ERROR: unterminated quoted string at or near "..."
Times Reported Most Frequent Error / Event #9
Day Hour Count Jul 09 09 3 16 1 - ERROR: unterminated quoted string at or near "'229760150004'');" at character 39
- ERROR: unterminated quoted string at or near "'229760150004'');" at character 39
- ERROR: unterminated quoted string at or near "'241672792531'');" at character 39
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA('229760150004'');
Date: 2026-07-09 09:05:41 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-09.log
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA('229760150004'');
Date: 2026-07-09 09:05:55 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-09.log
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA('241672792531'');
Date: 2026-07-09 09:25:28 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-09.log
10 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #10
Day Hour Count Jul 09 05 4 - ERROR: relation "rs_mv_equipamentos" does not exist
- ERROR: relation "rs_mv_codigos_barra" does not exist
- ERROR: relation "rs_mv_equipamentos" does not exist
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-09 05:32:09 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-09.log
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-09 05:32:09 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-09.log
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-09 05:32:09 Database: contagem Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-09.log
11 3 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #11
Day Hour Count Jul 09 03 3 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-07-09 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-09.log
Date: 2026-07-09 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-09.log
Date: 2026-07-09 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-09.log
12 3 LOG: process ... still waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #12
Day Hour Count Jul 09 09 1 13 2 - LOG: process 446904 still waiting for ShareLock on transaction 2384607 after 1000.231 ms
- LOG: process 624240 still waiting for ShareLock on transaction 2399670 after 1000.116 ms
- LOG: process 624240 still waiting for ShareLock on transaction 2399670 after 9988.228 ms
Detail: Process holding the lock: 446553. Wait queue: 446904.
Context: while updating tuple (73156,58) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-07-09 09:35:12 Database: rio Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-09.log
Detail: Process holding the lock: 609211. Wait queue: 624240.
Context: while deleting tuple (27,4) in relation "nf_entrada_arquivos" SQL statement "DELETE FROM NF_ENTRADA_ARQUIVOS WHERE NEA_ID = nNEA" PL/pgSQL function rs_nf_entrada_exclui(integer) line 57 at SQL statement
Statement: SELECT * FROM RS_NF_ENTRADA_EXCLUI(01513)Date: 2026-07-09 13:12:41 Database: contagem Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-09.log
Detail: Process holding the lock: 609211. Wait queue: 624240.
Context: while deleting tuple (27,4) in relation "nf_entrada_arquivos" SQL statement "DELETE FROM NF_ENTRADA_ARQUIVOS WHERE NEA_ID = nNEA" PL/pgSQL function rs_nf_entrada_exclui(integer) line 57 at SQL statement
Statement: SELECT * FROM RS_NF_ENTRADA_EXCLUI(01513)Date: 2026-07-09 13:12:50 Database: contagem Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-09.log
13 2 ERROR: canceling autovacuum task
Times Reported Most Frequent Error / Event #13
Day Hour Count Jul 09 11 1 14 1 - ERROR: canceling autovacuum task
- ERROR: canceling autovacuum task
Context: automatic vacuum of table "rio.public.temp0000284896"
Date: 2026-07-09 11:40:45 Log file: /usr/local/pgsql/data/log/serverlog-09.log
Context: automatic vacuum of table "rio.public.temp0000284968"
Date: 2026-07-09 14:35:47 Log file: /usr/local/pgsql/data/log/serverlog-09.log
14 2 LOG: process ... still waiting for AccessExclusiveLock on relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #14
Day Hour Count Jul 09 11 1 14 1 - LOG: process 550527 still waiting for AccessExclusiveLock on relation 2198630 of database 358220 after 1000.174 ms
- LOG: process 639497 still waiting for AccessExclusiveLock on relation 2219316 of database 358220 after 1000.150 ms
Detail: Process holding the lock: 584321. Wait queue: 550527.
Statement: DROP TABLE IF EXISTS temp0000284896;Date: 2026-07-09 11:40:45 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-09.log
Detail: Process holding the lock: 696922. Wait queue: 639497.
Statement: DROP TABLE IF EXISTS temp0000284968;Date: 2026-07-09 14:35:47 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-09.log
15 1 ERROR: update or delete on table "..." violates foreign key constraint "..." on table "..."
Times Reported Most Frequent Error / Event #15
Day Hour Count Jul 09 13 1 - ERROR: update or delete on table "nf_entrada_arquivos" violates foreign key constraint "nf_entrada_arquivo_erros_nea_id_fkey" on table "nf_entrada_arquivo_erros"
Detail: Key (nea_id)=(1513) is still referenced from table "nf_entrada_arquivo_erros".
Context: SQL statement "DELETE FROM NF_ENTRADA_ARQUIVOS WHERE NEA_ID = nNEA" PL/pgSQL function rs_nf_entrada_exclui(integer) line 57 at SQL statement
Statement: SELECT * FROM RS_NF_ENTRADA_EXCLUI(01513)Date: 2026-07-09 13:13:54 Database: contagem Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-09.log
16 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #16
Day Hour Count Jul 09 03 1 - LOG: database system was shut down at 2026-07-09 03:05:01 -03
Date: 2026-07-09 03:05:02 Log file: /usr/local/pgsql/data/log/serverlog-09.log