pgBadger-
Global information
- Generated on Sat Oct 10 23:50:09 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 5,806 log entries in 7s
- Log start from 2026-10-10 00:02:02 to 2026-10-10 23:42:59
-
Overview
Global Stats
- 166 Number of unique normalized queries
- 1,197 Number of queries
- 3h57m42s Total query duration
- 2026-10-10 00:02:06 First query
- 2026-10-10 23:42:59 Last query
- 5 queries/s at 2026-10-10 23:42:35 Query peak
- 3h57m42s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 3h57m42s Execute total duration
- 34 Number of events
- 8 Number of unique normalized events
- 16 Max number of times the same event was reported
- 0 Number of cancellation
- 27 Total number of automatic vacuums
- 53 Total number of automatic analyzes
- 20 Number temporary file
- 250.15 MiB Max size of temporary file
- 68.06 MiB Average size of temporary file
- 199 Total number of sessions
- 8 sessions at 2026-10-10 00:35:13 Session peak
- 7d13h50m51s Total duration of sessions
- 54m49s Average duration of sessions
- 6 Average queries per session
- 1m11s Average queries duration per session
- 53m38s Average idle time per session
- 209 Total number of connections
- 5 connections/s at 2026-10-10 03:05:16 Connection peak
- 4 Total number of databases
SQL Traffic
Key values
- 5 queries/s Query Peak
- 2026-10-10 23:42:35 Date
SELECT Traffic
Key values
- 3 queries/s Query Peak
- 2026-10-10 09:05:54 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 5 queries/s Query Peak
- 2026-10-10 23:42:35 Date
Queries duration
Key values
- 3h57m42s 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) Oct 10 00 29 0ms 20s999ms 3s613ms 8s564ms 1m3s 1m3s 01 18 0ms 3s774ms 2s196ms 6s839ms 7s513ms 7s513ms 02 18 0ms 3s876ms 1s991ms 6s110ms 6s492ms 6s492ms 03 17 0ms 4s858ms 2s166ms 7s213ms 8s763ms 8s763ms 04 18 0ms 5s816ms 2s607ms 9s792ms 9s792ms 9s792ms 05 22 0ms 9m31s 59s29ms 2m39s 6m45s 9m31s 06 19 0ms 9s666ms 2s762ms 5s518ms 26s864ms 26s864ms 07 80 0ms 6m55s 11s459ms 49s71ms 3m38s 6m55s 08 84 0ms 5m27s 7s777ms 5s48ms 15s987ms 5m59s 09 61 0ms 5m20s 10s64ms 6s358ms 3m21s 5m51s 10 68 0ms 5m21s 9s116ms 5s722ms 3m20s 5m50s 11 50 0ms 5m22s 12s252ms 4s602ms 3m24s 5m52s 12 26 0ms 5m23s 23s473ms 3m30s 5m54s 5m54s 13 42 0ms 5m14s 14s251ms 15s148ms 3m21s 5m45s 14 26 0ms 5m19s 22s873ms 3m20s 5m48s 5m48s 15 26 0ms 5m18s 22s884ms 3m22s 5m48s 5m48s 16 24 0ms 5m14s 24s463ms 3m20s 5m58s 5m58s 17 24 187ms 5m19s 24s777ms 3m21s 5m48s 5m48s 18 26 189ms 5m13s 22s598ms 3m19s 5m43s 5m43s 19 24 0ms 5m17s 24s839ms 3m24s 5m47s 5m47s 20 107 0ms 6m16s 11s743ms 1m17s 3m31s 6m36s 21 26 0ms 6m1s 24s495ms 3m25s 6m45s 6m45s 22 24 0ms 5m17s 25s284ms 3m36s 5m46s 5m46s 23 338 0ms 1m2s 5s817ms 1m5s 1m7s 1m16s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Oct 10 00 6 0 1s375ms 0ms 831ms 7s423ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 4 0 1s379ms 0ms 0ms 5s518ms 07 45 0 16s694ms 1s615ms 3s424ms 6m55s 08 44 0 13s731ms 1s278ms 2s159ms 5m59s 09 27 0 21s463ms 1s98ms 1s919ms 5m51s 10 35 0 16s737ms 1s637ms 2s559ms 5m50s 11 16 0 36s131ms 535ms 1s984ms 5m52s 12 8 0 1m12s 15s481ms 3m30s 5m54s 13 19 0 29s744ms 455ms 15s148ms 5m45s 14 8 0 1m10s 15s53ms 3m20s 5m48s 15 8 0 1m10s 702ms 3m22s 5m48s 16 6 0 1m33s 0ms 3m20s 5m58s 17 6 0 1m34s 15s9ms 3m21s 5m48s 18 8 0 1m9s 14s963ms 3m19s 5m43s 19 6 0 1m34s 15s34ms 3m24s 5m47s 20 8 80 13s818ms 1m7s 1m17s 6m16s 21 8 0 1m15s 504ms 3m21s 6m45s 22 6 0 1m36s 14s863ms 3m36s 5m46s 23 16 322 5s817ms 1m4s 1m5s 1m15s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Oct 10 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 Oct 10 00 0 1 1.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 5 5.00 0.00% 08 0 4 4.00 0.00% 09 0 1 1.00 0.00% 10 0 2 2.00 0.00% 11 0 2 2.00 0.00% 12 0 1 1.00 0.00% 13 0 2 2.00 0.00% 14 0 1 1.00 0.00% 15 0 1 1.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Day Hour Count Average / Second Oct 10 00 18 0.01/s 01 9 0.00/s 02 7 0.00/s 03 14 0.00/s 04 6 0.00/s 05 7 0.00/s 06 15 0.00/s 07 11 0.00/s 08 11 0.00/s 09 6 0.00/s 10 7 0.00/s 11 6 0.00/s 12 9 0.00/s 13 7 0.00/s 14 8 0.00/s 15 13 0.00/s 16 7 0.00/s 17 6 0.00/s 18 6 0.00/s 19 9 0.00/s 20 9 0.00/s 21 6 0.00/s 22 6 0.00/s 23 6 0.00/s Day Hour Count Average Duration Average idle time Oct 10 00 7 1h13s 59m58s 01 15 1h1m47s 1h1m45s 02 9 1h20s 1h16s 03 13 23m54s 23m51s 04 5 1h1m12s 1h1m2s 05 6 1h1m 57m24s 06 7 56m25s 56m18s 07 14 1h1m13s 1h7s 08 10 56m9s 55m4s 09 10 59m48s 58m46s 10 6 55m53s 54m9s 11 7 1h1m37s 1h10s 12 6 1h54s 59m12s 13 8 1h1m24s 1h9s 14 7 1h54s 59m29s 15 9 54m46s 53m40s 16 10 1h2m7s 1h1m8s 17 6 51m41s 50m2s 18 5 1h1m41s 59m43s 19 6 58m20s 56m40s 20 10 43m33s 41m27s 21 6 1h3s 58m17s 22 6 1h 58m19s 23 11 30m32s 27m33s -
Connections
Established Connections
Key values
- 5 connections Connection Peak
- 2026-10-10 03:05:16 Date
Connections per database
Key values
- brasilia Main Database
- 209 connections Total
Connections per user
Key values
- intelifix Main User
- 209 connections Total
-
Sessions
Simultaneous sessions
Key values
- 8 sessions Session Peak
- 2026-10-10 00:35:13 Date
Histogram of session times
Key values
- 168 3600000-28800000ms duration
Sessions per database
Key values
- brasilia Main Database
- 199 sessions Total
Sessions per user
Key values
- intelifix Main User
- 199 sessions Total
Sessions per host
Key values
- [local] Main Host
- 199 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 41,204 buffers Checkpoint Peak
- 2026-10-10 00:09:43 Date
- 269.981 seconds Highest write time
- 0.029 seconds Sync time
Checkpoints Wal files
Key values
- 7 files Wal files usage Peak
- 2026-10-10 00:19:43 Date
Checkpoints distance
Key values
- 201.28 Mo Distance Peak
- 2026-10-10 00:19:43 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Oct 10 00 60,396 750.57s 0.015s 750.618s 01 2,981 298.611s 0.011s 298.638s 02 2,566 256.83s 0.01s 256.856s 03 2,354 235.643s 0.04s 235.703s 04 3,553 355.491s 0.028s 355.535s 05 10,883 1,071.862s 0.046s 1,071.945s 06 4,357 269.981s 0.002s 269.985s 07 11,045 1,188.265s 0.033s 1,188.325s 08 7,445 764.723s 0.043s 764.796s 09 5,157 516.74s 0.041s 516.809s 10 4,977 498.615s 0.034s 498.676s 11 2,806 281.038s 0.023s 281.09s 12 35 3.533s 0.005s 3.546s 13 1,676 168.151s 0.023s 168.197s 14 41 4.132s 0.005s 4.143s 15 36 3.631s 0.005s 3.643s 16 23 2.312s 0.002s 2.316s 17 24 2.412s 0.002s 2.416s 18 339 33.992s 0.004s 34s 19 24 2.414s 0.002s 2.418s 20 151 15.151s 0.009s 15.168s 21 128 12.858s 0.006s 12.875s 22 27 2.728s 0.004s 2.741s 23 100 10.04s 0.004s 10.053s Day Hour Added Removed Recycled Synced files Longest sync Average sync Oct 10 00 0 0 12 527 0.002s 0.007s 01 0 0 1 476 0.002s 0.006s 02 0 0 1 401 0.002s 0.006s 03 0 0 1 338 0.019s 0.006s 04 0 0 1 457 0.004s 0.006s 05 0 0 5 845 0.010s 0.009s 06 0 0 0 11 0.001s 0.001s 07 0 0 9 889 0.002s 0.01s 08 0 0 2 1,247 0.002s 0.012s 09 0 0 2 1,058 0.002s 0.012s 10 0 0 1 895 0.002s 0.012s 11 0 0 1 766 0.002s 0.012s 12 0 0 0 15 0.001s 0.003s 13 0 0 0 608 0.002s 0.008s 14 0 0 0 20 0.001s 0.003s 15 0 0 0 16 0.001s 0.003s 16 0 0 0 3 0.001s 0.001s 17 0 0 0 3 0.001s 0.001s 18 0 0 0 42 0.002s 0.002s 19 0 0 0 3 0.001s 0.001s 20 0 0 1 32 0.005s 0.003s 21 0 0 0 26 0.001s 0.004s 22 0 0 0 6 0.001s 0.003s 23 0 0 0 22 0.002s 0.004s Day Hour Count Avg time (sec) Oct 10 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 Oct 10 00 27,852.14 kB 81,075.43 kB 01 2,592.00 kB 44,111.33 kB 02 2,209.67 kB 24,539.17 kB 03 1,946.43 kB 5,602.86 kB 04 3,389.83 kB 4,960.50 kB 05 8,223.22 kB 16,103.33 kB 06 8,273.00 kB 13,795.00 kB 07 14,184.60 kB 25,495.80 kB 08 3,181.58 kB 24,892.00 kB 09 1,943.00 kB 8,804.67 kB 10 1,863.83 kB 4,053.00 kB 11 1,091.92 kB 3,329.67 kB 12 75.33 kB 1,819.67 kB 13 1,041.88 kB 1,595.88 kB 14 82.00 kB 1,901.00 kB 15 74.33 kB 1,416.67 kB 16 189.00 kB 1,164.00 kB 17 190.00 kB 1,067.00 kB 18 636.00 kB 1,023.00 kB 19 189.00 kB 902.00 kB 20 771.00 kB 1,069.00 kB 21 139.00 kB 823.75 kB 22 65.67 kB 582.00 kB 23 72.67 kB 451.67 kB -
Temporary Files
Size of temporary files
Key values
- 250.15 MiB Temp Files size Peak
- 2026-10-10 05:31:56 Date
Number of temporary files
Key values
- 4 per second Temp Files Peak
- 2026-10-10 05:32:02 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Oct 10 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 20 1.33 GiB 68.06 MiB 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 16 1.03 GiB 37.31 MiB 250.15 MiB 65.65 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-10-10 05:32:05 Duration: 1m24s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-10-10 05:31:56 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 4 310.72 MiB 57.75 MiB 95.05 MiB 77.68 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-10-10 05:30:41 Duration: 39s808ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-10-10 05:30:37 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
Queries generating the largest temporary files
Rank Size Query 1 250.15 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-10 05:31:56 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 250.15 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-10 05:31:57 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 95.05 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-10-10 05:30:37 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 95.05 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-10-10 05:30:37 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 62.87 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-10-10 05:30:40 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 57.75 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-10-10 05:30:41 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 41.32 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-10 05:32:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 41.26 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-10 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 41.26 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-10 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 41.26 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-10 05:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 41.26 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-10 05:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 41.26 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-10 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 41.25 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-10 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 37.37 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-10 05:32:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 37.31 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-10 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 37.31 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-10 05:32:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 37.31 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-10 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 37.31 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-10 05:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 37.31 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-10 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 37.31 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-10 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 2.47 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_10
Database rio - 2026-10-10 00:05:45 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 2.47 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_10
Database rio - 2026-10-10 00:05:45 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (11) Main table analyzed (database rio)
- 53 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 11 rio.public.temp0000293926 9 rio.public.temp0000293914 6 rio.public.temp0000293928 5 rio.pg_catalog.pg_class 5 rio.pg_catalog.pg_type 4 rio.public.temp0000293934 3 brasilia.public.temp0000241994 2 rio.pg_catalog.pg_depend 2 rio.pg_catalog.pg_index 2 rio.public.temp0000293918 1 rio.public.temp0000293938 1 rio.public.temp0000293920 1 rio.public.temp0000293912 1 Total 53 Vacuums per table
Key values
- public.temp0000293928 (5) Main table vacuumed on database rio
- 27 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.temp0000293928 5 0 0 0 0 0 0 9,300 20 551,715 0 0 rio.pg_catalog.pg_attribute 4 4 0 0 0 0 0 2,250 771 1,047,575 18 509 rio.public.temp0000293926 2 0 0 0 0 0 0 173 12 12,035 0 0 rio.pg_catalog.pg_class 2 2 0 0 0 0 0 474 164 217,867 7 18 contagem.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,190 7 158,974 0 0 rio.auditor.auditor_2026_10 1 0 0 0 0 0 0 29,944 29,649 36,491,321 86 1,190 brasilia.pg_catalog.pg_statistic 1 1 0 0 0 0 0 3,128 910 3,662,325 870 5,965 rio.pg_catalog.pg_statistic 1 1 0 0 0 0 0 3,102 244 1,172,138 212 1,313 rio.public.temp0000293918 1 0 0 0 0 0 0 87 6 6,047 0 0 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 150 3 16,016 0 0 rio.public.temp0000293914 1 0 0 0 0 0 0 86 84 165,855 0 0 rio.public.temp0000293920 1 0 0 0 0 0 0 86 6 5,988 0 0 brasilia.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 217 51 234,857 32 74 rio.public.temp0000293934 1 0 0 0 0 0 0 87 6 6,048 0 0 rio.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 793 87 563,181 46 112 rio.pg_catalog.pg_depend 1 1 0 0 0 0 0 479 167 250,427 2 12 rio.pg_catalog.pg_type 1 1 0 0 0 0 0 133 57 67,361 2 8 rio.pg_catalog.pg_index 1 1 0 0 0 0 0 87 29 21,941 0 0 Total 27 15 0 0 0 0 0 52,766 32,273 44,651,671 1,275 9,201 Vacuum throughput per table
Key values
- auditor.auditor_2026_10 (2.47) 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.temp0000293928 0 0 0.2 rio.pg_catalog.pg_attribute 0 0 0.39 rio.public.temp0000293926 0 0 0.01 rio.pg_catalog.pg_class 0 0 0.18 contagem.pg_catalog.pg_statistic 0 0 0.05 rio.auditor.auditor_2026_10 0 0 2.47 brasilia.pg_catalog.pg_statistic 0 0 0.28 rio.pg_catalog.pg_statistic 0 0 0.17 rio.public.temp0000293918 0 0 0 contagem.pg_toast.pg_toast_2619 0 0 0 rio.public.temp0000293914 0 0 0.01 rio.public.temp0000293920 0 0 0 brasilia.pg_toast.pg_toast_2619 0 0 0.01 rio.public.temp0000293934 0 0 0 rio.pg_toast.pg_toast_2619 0 0 0.04 rio.pg_catalog.pg_depend 0 0 0.18 rio.pg_catalog.pg_type 0 0 0.06 rio.pg_catalog.pg_index 0 0 0.03 Total 0 0 4.08 Tuples removed per table
Key values
- pg_catalog.pg_attribute (13384) Main table with removed tuples on database rio
- 30193 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 4 4 13,384 88,735 0 28 2,264 rio.pg_catalog.pg_statistic 1 1 4,493 7,481 0 0 1,286 contagem.pg_catalog.pg_statistic 1 1 4,380 7,274 0 0 1,011 brasilia.pg_catalog.pg_statistic 1 1 3,982 7,360 0 0 1,071 rio.auditor.auditor_2026_10 1 0 1,301 5,719,369 0 0 274,406 rio.pg_catalog.pg_depend 1 1 879 18,777 0 0 188 rio.pg_toast.pg_toast_2619 1 1 702 675 0 0 280 rio.pg_catalog.pg_class 2 2 389 8,431 0 0 268 rio.pg_catalog.pg_index 1 1 289 1,887 0 3 52 brasilia.pg_toast.pg_toast_2619 1 1 137 138 0 0 72 rio.pg_catalog.pg_type 1 1 129 2,215 0 0 73 contagem.pg_toast.pg_toast_2619 1 1 128 118 0 0 59 rio.public.temp0000293918 1 0 0 1,256 0 49 79 rio.public.temp0000293928 5 0 0 132,186 0 0 9,280 rio.public.temp0000293926 2 0 0 2,500 0 99 157 rio.public.temp0000293914 1 0 0 1,244 0 50 78 rio.public.temp0000293920 1 0 0 1,244 0 50 78 rio.public.temp0000293934 1 0 0 1,256 0 49 79 Total 27 15 30,193 6,002,146 0 328 290,781 Pages removed per table
Key values
- public.temp0000293926 (99) Main table with removed pages on database rio
- 328 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.public.temp0000293926 2 0 0 99 rio.public.temp0000293914 1 0 0 50 rio.public.temp0000293920 1 0 0 50 rio.public.temp0000293918 1 0 0 49 rio.public.temp0000293934 1 0 0 49 rio.pg_catalog.pg_attribute 4 4 13384 28 rio.pg_catalog.pg_index 1 1 289 3 contagem.pg_catalog.pg_statistic 1 1 4380 0 rio.auditor.auditor_2026_10 1 0 1301 0 brasilia.pg_catalog.pg_statistic 1 1 3982 0 rio.pg_catalog.pg_statistic 1 1 4493 0 rio.public.temp0000293928 5 0 0 0 contagem.pg_toast.pg_toast_2619 1 1 128 0 brasilia.pg_toast.pg_toast_2619 1 1 137 0 rio.pg_toast.pg_toast_2619 1 1 702 0 rio.pg_catalog.pg_class 2 2 389 0 rio.pg_catalog.pg_depend 1 1 879 0 rio.pg_catalog.pg_type 1 1 129 0 Total 27 15 30,193 328 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Oct 10 00 2 1 01 0 0 02 0 0 03 0 0 04 0 0 05 6 0 06 0 0 07 12 18 08 3 7 09 0 6 10 1 8 11 1 7 12 0 0 13 2 6 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 - 2.47 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- AccessExclusiveLock Main Lock Type
- 1 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 1 1s 1s 1s 1s drop table if exists temp0000293928;-
DROP TABLE IF EXISTS temp0000293928;
Date: 2026-10-10 07:36:35 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
DROP TABLE IF EXISTS temp0000293928;
Date: 2026-10-10 07:36:35 Database: rio User: intelifix Remote: [local] Application: [unknown]
Queries that waited the most
Rank Wait time Query 1 1s DROP TABLE IF EXISTS temp0000293928;[ Date: 2026-10-10 07:36:35 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
-
Queries
Queries by type
Key values
- 284 Total read queries
- 499 Total write queries
Queries by database
Key values
- rio Main database
- 648 Requests
- 2h34m54s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 1,169 Requests
User Request type Count Duration intelifix Total 1,169 3h57m23s copy to 402 41m51s ddl 97 2m59s others 414 34m34s select 256 2h37m57s lenon Total 28 19s150ms select 28 19s150ms Duration by user
Key values
- 3h57m23s (intelifix) Main time consuming user
User Request type Count Duration intelifix Total 1,169 3h57m23s copy to 402 41m51s ddl 97 2m59s others 414 34m34s select 256 2h37m57s lenon Total 28 19s150ms select 28 19s150ms Queries by host
Key values
- [local] Main host
- 1,197 Requests
- 3h57m42s ([local])
- Main time consuming host
Queries by application
Key values
- psql Main application
- 525 Requests
- 3h11m11s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-10-10 11:53:36 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 449 100-500ms duration
Slowest individual queries
Rank Duration Query 1 9m31s analyze verbose;[ Date: 2026-10-10 05:09:32 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 6m55s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-10 07:11:57 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 6m45s analyze verbose;[ Date: 2026-10-10 05:16:17 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
4 6m16s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-10 20:11:17 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 6m1s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-10 21:11:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 5m27s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-10 08:10:29 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 5m23s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-10 12:10:25 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 5m22s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-10 11:10:24 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 5m21s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-10 10:10:23 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 5m20s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-10 09:10:22 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 5m19s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-10 17:10:21 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 5m19s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-10 14:10:20 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 5m18s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-10 15:10:19 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 5m17s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-10 19:10:19 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 5m17s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-10 22:10:18 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 5m14s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-10 13:10:16 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 5m14s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-10 16:10:15 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 5m13s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-10 18:10:15 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 3m33s SELECT * FROM RS_SMART_FISCAL_SAIDA ();[ Date: 2026-10-10 22:14:36 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
20 3m31s SELECT * FROM RS_SMART_FISCAL_SAIDA ();[ Date: 2026-10-10 07:17:03 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 1h33m30s 48 2s342ms 6m55s 1m56s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 10 07 3 7m30s 2m30s 08 3 5m45s 1m55s 09 3 5m38s 1m52s 10 3 5m38s 1m52s 11 3 5m40s 1m53s 12 3 5m41s 1m53s 13 3 5m32s 1m50s 14 3 5m36s 1m52s 15 3 5m35s 1m51s 16 3 5m31s 1m50s 17 3 5m36s 1m52s 18 3 5m31s 1m50s 19 3 5m35s 1m51s 20 3 6m42s 2m14s 21 3 6m19s 2m6s 22 3 5m34s 1m51s [ User: intelifix - Total duration: 1h33m30s - Times executed: 48 ]
[ Application: psql - Total duration: 1h33m30s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-10 07:11:57 Duration: 6m55s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-10 20:11:17 Duration: 6m16s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-10 21:11:03 Duration: 6m1s Database: rio User: intelifix Remote: [local] Application: psql
2 1h2m47s 47 230ms 3m33s 1m20s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 10 07 3 4m39s 1m33s 08 3 3m48s 1m16s 09 3 3m47s 1m15s 10 3 3m47s 1m15s 11 3 3m52s 1m17s 12 3 3m59s 1m19s 13 3 3m48s 1m16s 14 3 3m48s 1m16s 15 3 3m50s 1m16s 16 3 3m46s 1m15s 17 3 3m48s 1m16s 18 3 3m46s 1m15s 19 3 3m51s 1m17s 20 2 4m22s 2m11s 21 3 3m48s 1m16s 22 3 4m3s 1m21s [ User: intelifix - Total duration: 1h2m47s - Times executed: 47 ]
[ Application: psql - Total duration: 1h2m47s - Times executed: 47 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-10 22:14:36 Duration: 3m33s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-10 07:17:03 Duration: 3m31s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-10 12:14:40 Duration: 3m27s Database: brasilia User: intelifix Remote: [local] Application: psql
3 18m56s 3 2m39s 9m31s 6m18s analyze verbose;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 10 05 3 18m56s 6m18s [ User: intelifix - Total duration: 18m56s - Times executed: 3 ]
[ Application: psql - Total duration: 18m56s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-10-10 05:09:32 Duration: 9m31s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-10-10 05:16:17 Duration: 6m45s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-10-10 05:18:57 Duration: 2m39s Database: contagem User: intelifix Remote: [local] Application: psql
4 9m28s 263 184ms 8s443ms 2s163ms call rs_giga_triagem (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 10 00 12 29s582ms 2s465ms 01 12 23s511ms 1s959ms 02 12 23s812ms 1s984ms 03 12 23s795ms 1s982ms 04 12 23s876ms 1s989ms 05 12 23s883ms 1s990ms 06 12 24s207ms 2s17ms 07 12 24s268ms 2s22ms 08 12 24s208ms 2s17ms 09 12 24s919ms 2s76ms 10 12 24s706ms 2s58ms 11 12 23s839ms 1s986ms 12 12 24s157ms 2s13ms 13 11 23s816ms 2s165ms 14 10 24s62ms 2s406ms 15 11 23s513ms 2s137ms 16 11 23s896ms 2s172ms 17 11 24s438ms 2s221ms 18 10 23s924ms 2s392ms 19 11 24s194ms 2s199ms 20 11 34s533ms 3s139ms 21 10 23s706ms 2s370ms 22 11 24s69ms 2s188ms [ User: intelifix - Total duration: 9m28s - Times executed: 263 ]
[ Application: psql - Total duration: 9m28s - Times executed: 263 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-10 20:05:09 Duration: 8s443ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-10 00:05:30 Duration: 7s892ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-10 20:15:08 Duration: 7s284ms Database: rio User: intelifix Remote: [local] Application: psql
5 2m14s 4 4s342ms 1m2s 33s521ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 10 20 2 1m6s 33s488ms 23 2 1m7s 33s554ms [ User: intelifix - Total duration: 2m14s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m14s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-10-10 23:16:40 Duration: 1m2s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-10-10 20:08:39 Duration: 1m2s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-10-10 23:33:56 Duration: 4s343ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
6 1m52s 34 407ms 20s999ms 3s300ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 10 00 6 33s766ms 5s627ms 01 6 16s25ms 2s670ms 02 6 12s28ms 2s4ms 03 5 13s33ms 2s606ms 04 6 23s52ms 3s842ms 05 5 14s300ms 2s860ms [ User: intelifix - Total duration: 1m52s - Times executed: 34 ]
[ Application: psql - Total duration: 1m52s - Times executed: 34 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-10 00:05:22 Duration: 20s999ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-10 04:45:07 Duration: 5s816ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-10 05:25:06 Duration: 5s745ms Database: rio User: intelifix Remote: [local] Application: psql
7 1m48s 6 3s276ms 40s281ms 18s44ms copy public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Oct 10 20 3 54s119ms 18s39ms 23 3 54s147ms 18s49ms [ User: intelifix - Total duration: 1m48s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m48s - Times executed: 6 ]
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-10-10 20:06:26 Duration: 40s281ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-10-10 23:14:26 Duration: 40s109ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-10-10 23:33:32 Duration: 10s583ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
8 1m47s 4 365ms 53s489ms 26s801ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Oct 10 20 2 53s866ms 26s933ms 23 2 53s341ms 26s670ms [ User: intelifix - Total duration: 1m47s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m47s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-10-10 20:05:44 Duration: 53s489ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-10-10 23:13:44 Duration: 52s976ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-10-10 20:10:03 Duration: 376ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
9 1m41s 7 10s551ms 35s490ms 14s454ms create table temp0000293928 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Oct 10 07 7 1m41s 14s454ms [ User: intelifix - Total duration: 1m41s - Times executed: 7 ]
[ Application: [unknown] - Total duration: 1m41s - Times executed: 7 ]
-
CREATE TABLE temp0000293928 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-10 07:36:23 Duration: 35s490ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293928 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-10 07:41:52 Duration: 11s268ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293928 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-10 07:41:32 Duration: 11s123ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 1m24s 1 1m24s 1m24s 1m24s refresh materialized view concurrently rs_mv_codigos_barra;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Oct 10 05 1 1m24s 1m24s [ User: intelifix - Total duration: 1m24s - Times executed: 1 ]
[ Application: psql - Total duration: 1m24s - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-10-10 05:32:05 Duration: 1m24s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-10-10 05:31:56 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
11 1m23s 6 2s292ms 31s898ms 13s988ms copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 10 20 3 41s985ms 13s995ms 23 3 41s944ms 13s981ms [ User: intelifix - Total duration: 1m23s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m23s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-10-10 20:07:00 Duration: 31s898ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-10-10 23:15:01 Duration: 31s767ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-10-10 23:33:40 Duration: 7s878ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
12 1m23s 6 3s51ms 32s566ms 13s974ms copy public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 10 20 3 41s715ms 13s905ms 23 3 42s133ms 14s44ms [ User: intelifix - Total duration: 1m23s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m23s - Times executed: 6 ]
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-10-10 23:17:13 Duration: 32s566ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-10-10 20:09:12 Duration: 32s108ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-10-10 20:10:44 Duration: 6s556ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
13 1m14s 102 150ms 2s877ms 730ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 10 07 19 12s292ms 646ms 08 26 24s265ms 933ms 09 18 13s139ms 729ms 10 24 18s494ms 770ms 11 6 3s613ms 602ms 13 9 2s721ms 302ms [ User: intelifix - Total duration: 1m14s - Times executed: 102 ]
[ Application: [unknown] - Total duration: 1m14s - Times executed: 102 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (295047, 433, 'ZTE3ANNR9W44854,D89A0DAC7767,D89A0DAC7768,ZTEGDB16C0E1$ZTE3ANNR7B32722,3891484BEB93,3891484BEB94,ZTEGDB081132$ZTE3ANNRC559721,6C11BA67A18D,6C11BA67A18E,ZTEGDC6EFF08$ZTE3ANNQ4N00256,3CF9F0A897AE,3CF9F0A897AF,ZTEGD64103FB$ZTE3ANNQ9J34618,843C992EFC91,843C992EFC92,ZTEGD7BB8FE5$ZTE3ANNR8C27911,389148511531,389148511532,ZTEGDB08ED77$ZTE3ANNRC560302,6C11BA67AF2B,6C11BA67AF2C,ZTEGDC6F014D$ZTE3ANNRCB03366,D831391E1DE2,D831391E1DE3,ZTEGDD29C2BB$ZTE3ANNR5W51120,48D6823331EA,48D6823331EB,ZTEGDB00C7AF$ZTE3ANNR5W17979,48D68230292C,48D68230292D,ZTEGDB00463A$ZTE3ANNR1Y02166,14CA56CCDD3F,14CA56CCDD40,ZTEGD9707ED1$ZTE3ANNT4P36556,F00C514EFF66,F00C514EFF67,ZTEGDE348562$ZTE3ANNT3H84344,D831399E7C68,D831399E7C69,ZTEGDD331A17$ZTE3ANNQ8F14788,689E29FD7D75,689E29FD7D76,ZTEGD7BA3694$ZTE3ANNT3H44911,D831399AE032,D831399AE033,ZTEGDD32800E$ZTE3ANNR4N17831,4896D956FD02,4896D956FD03,ZTEGD97F656C$ZTE3ANNRCB23843,D831391FFDD0,D831391FFDD1,ZTEGDD2A12B8$ZTE3ANNT7U11859,5892040115EC,5892040115ED,ZTEGDF031B47$ZTE3ANNRAD22617,D89A0DAFEC79,D89A0DAFEC7A,ZTEGDB175464$ZTE3ANNR3J30395,F4E84F8916C2,F4E84F8916C3,ZTEGD97BD885$ZTE3ANNR9329835,D89A0D851B4D,D89A0D851B4E,ZTEGDB14E88A$ZTE3ANNQ4414427,3CF9F0ACB100,3CF9F0ACB101,ZTEGD641B2DE$ZTE3ANNR4N06335,4896D955EF92,4896D955EF93,ZTEGD97F3884$ZTE3ANNT4P37247,F00C514F0F98,F00C514F0F99,ZTEGDE348815$ZTE3ANNT3H17681,D831399861FE,D831399861FF,ZTEGDD3215B0$ZTE3ANNRAM42157,5872C98B1447,5872C98B1448,ZTEGDC60A4AC$ZTE3ANNR9F16778,D89A0DA4671F,D89A0DA46720,ZTEGDB1568D5$ZTE3ANNR9W45041,D89A0DAC7BC9,D89A0DAC7BCA,ZTEGDB16C19C$ZTE3ANNT3J10159,D83139A0D96C,D83139A0D96D,ZTEGDD337EED$ZTE3ANNT2V11527,D831398C9D02,D831398C9D03,ZTEGDD301F86$ZTE3ANNR1Y08338,14CA56CD6DE7,14CA56CD6DE8,ZTEGD97096ED$ZTE3ANNRB713485,5872C98F753F,5872C98F7540,ZTEGDC615F80$ZTE3ANNRC575871,6C11BA691C11,6C11BA691C12,ZTEGDC6F3E1E$ZTE3ANNQ8F12886,689E29FD50E1,689E29FD50E2,ZTEGD7BA2F26$ZTE3ANNR4N03475,4896D955AC8A,4896D955AC8B,ZTEGD97F2D58$ZTE3ANNR3Y01522,4896D94FE464,4896D94FE465,ZTEGD97E36A7$ZTE3ANNR1Y54287,14CA56D1A2D5,14CA56D1A2D6,ZTEGD9714A6A$ZTE3ANNQ7L04432,C4EBFF8DEC88,C4EBFF8DEC89,ZTEGD70ACD82$ZTE3ANNR2Q09314,F4E84F818E4C,F4E84F818E4D,ZTEGD97A971C$ZTE3ANNR8C34312,38914851AB37,38914851AB38,ZTEGDB090678', '',0318,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-10-10 08:17:02 Duration: 2s877ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (295034, 433, 'ZTEKH7VP3A10716,D8E8448B996A$ZTEAH7VQ5H00527,6877DA60966B$ZTEAH7VPCD09947,F42D06481473$ZTEAH7VQ6L08329,6877DA62B6AB$ZTEAH7VQ6H01100,6877DA618E6F$ZTEAH7VQ5H00675,6877DA6098BB$ZTEAH7VQ2V15958,6877DA5CDC37$ZTEAH7VQ6H04741,6877DA61C753$ZTEAH7VQA314833,802D1A2081C0$ZTEKH7VP3A10746,D8E8448B99E2$ZTEAH7VQ3L11885,6877DA5F69C3$ZTEAH7VQA300612,802D1A1FA38C$ZTEAH7VQ3L01240,6877DA5EC36F$ZTEAH7VQ3L11441,6877DA5F62D3$ZTEKH7VP2P05863,CC29BDED6A01$ZTEKH7VP3A10725,D8E8448B998E$ZTEAH7VQ8P19576,802D1A1F8D1C$ZTEAH7VPCD04249,F42D0647BB6B$ZTEKH7VP3A10736,D8E8448B99BA$ZTEAH7VQ3L08283,6877DA5F317B$ZTEKH7VP3A10726,D8E8448B9992$ZTEAH7VQ3L08040,6877DA5F2DAF$ZTEAH7VQ3L01038,6877DA5EC047$ZTEAH7VQ3L01166,6877DA5EC247$ZTEAH7VQAQ26482,203AEBA722B6$ZTEAH7VQ3L04614,6877DA5EF827$ZTEAH7VPBU18207,F42D0645C803$ZTEAH7VQ8P12076,802D1A1F17EC$ZTEAH7VPCD03840,F42D0647B507$ZTEAH7VQ3L11660,6877DA5F663F$ZTEKH7VP3A10721,D8E8448B997E$ZTEAH7VQ3L04091,6877DA5EEFFB$ZTEAH7VQ5H00489,6877DA6095D3$ZTEKH7VP3A10749,D8E8448B99EE', '',0301,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-10-10 08:08:08 Duration: 2s113ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (295053, 404, 'C492D945B9A3,ZTE3A8TT7P06931DB36,ZTE3A8TT4X13213$C492D945BCAF,ZTE3A8TT7P07126F176,ZTE3A8TT4723753,ZTE3A8TT3R18705$C492D945B92B,ZTE3A8TT7P06901F01E,ZTE3A8TT4723667$DC5193D8F186,ZTE3A8TQCH06560$C492D945BACB,ZTE3A8TT7P07005$C492D945BABF,ZTE3A8TT7P07002C7D21EEFABF,ZTE3A8TRCP14035$E44E12B2432D,ZTE3A8TR7922407$E44E12B243A9,ZTE3A8TR7922438DD16,ZTE3A8TT3R15181C7D21F20AC3,ZTE3A8TT2L13212C7D21EE51D3,ZTE3A8TRCP03224DDE2,ZTE3A8TT3R15232$DC5193D8F06A,ZTE3A8TQCH06489$E44E12B209D9,ZTE3A8TR7918738A42,ZTE3A8TT3R10904E376,ZTE3A8TT4722857A09E6,ZTE3A8TT4X16201$C492D945BF13,ZTE3A8TT7P07279$E44E12B212BD,ZTE3A8TR7919307$B47CA609970A,ZTE3A8TR8U31130$C492D945BEFB,ZTE3A8TT7P07273$E44E12B2156D,ZTE3A8TR7919479C7D21F01B73,ZTE3A8TRCS07012C7D21ECD8A7,ZTE3A8TRCB04585C7D21ED80AF,ZTE3A8TRCB15339', '',0461,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-10-10 09:17:38 Duration: 1s919ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 1m11s 6 2s533ms 23s655ms 11s960ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Oct 10 20 3 35s863ms 11s954ms 23 3 35s901ms 11s967ms [ User: intelifix - Total duration: 1m11s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m11s - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-10-10 20:02:46 Duration: 23s655ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-10-10 23:10:47 Duration: 23s483ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-10-10 23:32:49 Duration: 9s850ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
15 1m11s 6 2s232ms 24s216ms 11s873ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 10 20 3 35s688ms 11s896ms 23 3 35s551ms 11s850ms [ User: intelifix - Total duration: 1m11s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m11s - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-10-10 20:03:27 Duration: 24s216ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-10-10 23:11:28 Duration: 24s134ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-10-10 20:09:43 Duration: 9s239ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
16 1m4s 6 1s692ms 25s374ms 10s717ms copy public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 10 20 3 32s52ms 10s684ms 23 3 32s254ms 10s751ms [ User: intelifix - Total duration: 1m4s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m4s - Times executed: 6 ]
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-10-10 23:12:27 Duration: 25s374ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-10-10 20:04:26 Duration: 25s365ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-10-10 23:33:16 Duration: 5s112ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
17 55s865ms 4 4s271ms 23s746ms 13s966ms copy public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Oct 10 20 2 27s846ms 13s923ms 23 2 28s19ms 14s9ms [ User: intelifix - Total duration: 55s865ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 55s865ms - Times executed: 4 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-10-10 23:12:51 Duration: 23s746ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-10-10 20:04:50 Duration: 23s574ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-10-10 23:33:21 Duration: 4s273ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
18 55s520ms 6 5s979ms 13s43ms 9s253ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 10 00 3 32s763ms 10s921ms 06 3 22s756ms 7s585ms [ User: intelifix - Total duration: 55s520ms - Times executed: 6 ]
[ Application: psql - Total duration: 55s520ms - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-10-10 00:05:25 Duration: 13s43ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-10-10 00:05:12 Duration: 10s557ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-10-10 06:05:18 Duration: 9s666ms Database: brasilia User: intelifix Remote: [local] Application: psql
19 51s749ms 6 1s832ms 16s840ms 8s624ms copy public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 10 20 3 25s822ms 8s607ms 23 3 25s926ms 8s642ms [ User: intelifix - Total duration: 51s749ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 51s749ms - Times executed: 6 ]
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-10-10 20:03:44 Duration: 16s840ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-10-10 23:11:45 Duration: 16s710ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-10-10 23:33:09 Duration: 7s361ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
20 41s568ms 53 566ms 980ms 784ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 10 08 3 2s279ms 759ms 09 4 3s105ms 776ms 10 3 2s394ms 798ms 11 4 2s933ms 733ms 12 3 2s243ms 747ms 13 3 2s341ms 780ms 14 3 2s297ms 765ms 15 4 2s997ms 749ms 16 4 3s136ms 784ms 17 4 3s390ms 847ms 18 4 3s127ms 781ms 19 3 2s488ms 829ms 20 4 3s186ms 796ms 21 4 3s234ms 808ms 22 3 2s411ms 803ms [ User: intelifix - Total duration: 41s568ms - Times executed: 53 ]
[ Application: psql - Total duration: 41s568ms - Times executed: 53 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-10 17:20:02 Duration: 980ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-10 09:00:03 Duration: 970ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-10 08:00:05 Duration: 950ms Database: brasilia User: intelifix Remote: [local] Application: psql
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 263 9m28s 184ms 8s443ms 2s163ms call rs_giga_triagem (?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 10 00 12 29s582ms 2s465ms 01 12 23s511ms 1s959ms 02 12 23s812ms 1s984ms 03 12 23s795ms 1s982ms 04 12 23s876ms 1s989ms 05 12 23s883ms 1s990ms 06 12 24s207ms 2s17ms 07 12 24s268ms 2s22ms 08 12 24s208ms 2s17ms 09 12 24s919ms 2s76ms 10 12 24s706ms 2s58ms 11 12 23s839ms 1s986ms 12 12 24s157ms 2s13ms 13 11 23s816ms 2s165ms 14 10 24s62ms 2s406ms 15 11 23s513ms 2s137ms 16 11 23s896ms 2s172ms 17 11 24s438ms 2s221ms 18 10 23s924ms 2s392ms 19 11 24s194ms 2s199ms 20 11 34s533ms 3s139ms 21 10 23s706ms 2s370ms 22 11 24s69ms 2s188ms [ User: intelifix - Total duration: 9m28s - Times executed: 263 ]
[ Application: psql - Total duration: 9m28s - Times executed: 263 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-10 20:05:09 Duration: 8s443ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-10 00:05:30 Duration: 7s892ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-10 20:15:08 Duration: 7s284ms Database: rio User: intelifix Remote: [local] Application: psql
2 102 1m14s 150ms 2s877ms 730ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 10 07 19 12s292ms 646ms 08 26 24s265ms 933ms 09 18 13s139ms 729ms 10 24 18s494ms 770ms 11 6 3s613ms 602ms 13 9 2s721ms 302ms [ User: intelifix - Total duration: 1m14s - Times executed: 102 ]
[ Application: [unknown] - Total duration: 1m14s - Times executed: 102 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (295047, 433, 'ZTE3ANNR9W44854,D89A0DAC7767,D89A0DAC7768,ZTEGDB16C0E1$ZTE3ANNR7B32722,3891484BEB93,3891484BEB94,ZTEGDB081132$ZTE3ANNRC559721,6C11BA67A18D,6C11BA67A18E,ZTEGDC6EFF08$ZTE3ANNQ4N00256,3CF9F0A897AE,3CF9F0A897AF,ZTEGD64103FB$ZTE3ANNQ9J34618,843C992EFC91,843C992EFC92,ZTEGD7BB8FE5$ZTE3ANNR8C27911,389148511531,389148511532,ZTEGDB08ED77$ZTE3ANNRC560302,6C11BA67AF2B,6C11BA67AF2C,ZTEGDC6F014D$ZTE3ANNRCB03366,D831391E1DE2,D831391E1DE3,ZTEGDD29C2BB$ZTE3ANNR5W51120,48D6823331EA,48D6823331EB,ZTEGDB00C7AF$ZTE3ANNR5W17979,48D68230292C,48D68230292D,ZTEGDB00463A$ZTE3ANNR1Y02166,14CA56CCDD3F,14CA56CCDD40,ZTEGD9707ED1$ZTE3ANNT4P36556,F00C514EFF66,F00C514EFF67,ZTEGDE348562$ZTE3ANNT3H84344,D831399E7C68,D831399E7C69,ZTEGDD331A17$ZTE3ANNQ8F14788,689E29FD7D75,689E29FD7D76,ZTEGD7BA3694$ZTE3ANNT3H44911,D831399AE032,D831399AE033,ZTEGDD32800E$ZTE3ANNR4N17831,4896D956FD02,4896D956FD03,ZTEGD97F656C$ZTE3ANNRCB23843,D831391FFDD0,D831391FFDD1,ZTEGDD2A12B8$ZTE3ANNT7U11859,5892040115EC,5892040115ED,ZTEGDF031B47$ZTE3ANNRAD22617,D89A0DAFEC79,D89A0DAFEC7A,ZTEGDB175464$ZTE3ANNR3J30395,F4E84F8916C2,F4E84F8916C3,ZTEGD97BD885$ZTE3ANNR9329835,D89A0D851B4D,D89A0D851B4E,ZTEGDB14E88A$ZTE3ANNQ4414427,3CF9F0ACB100,3CF9F0ACB101,ZTEGD641B2DE$ZTE3ANNR4N06335,4896D955EF92,4896D955EF93,ZTEGD97F3884$ZTE3ANNT4P37247,F00C514F0F98,F00C514F0F99,ZTEGDE348815$ZTE3ANNT3H17681,D831399861FE,D831399861FF,ZTEGDD3215B0$ZTE3ANNRAM42157,5872C98B1447,5872C98B1448,ZTEGDC60A4AC$ZTE3ANNR9F16778,D89A0DA4671F,D89A0DA46720,ZTEGDB1568D5$ZTE3ANNR9W45041,D89A0DAC7BC9,D89A0DAC7BCA,ZTEGDB16C19C$ZTE3ANNT3J10159,D83139A0D96C,D83139A0D96D,ZTEGDD337EED$ZTE3ANNT2V11527,D831398C9D02,D831398C9D03,ZTEGDD301F86$ZTE3ANNR1Y08338,14CA56CD6DE7,14CA56CD6DE8,ZTEGD97096ED$ZTE3ANNRB713485,5872C98F753F,5872C98F7540,ZTEGDC615F80$ZTE3ANNRC575871,6C11BA691C11,6C11BA691C12,ZTEGDC6F3E1E$ZTE3ANNQ8F12886,689E29FD50E1,689E29FD50E2,ZTEGD7BA2F26$ZTE3ANNR4N03475,4896D955AC8A,4896D955AC8B,ZTEGD97F2D58$ZTE3ANNR3Y01522,4896D94FE464,4896D94FE465,ZTEGD97E36A7$ZTE3ANNR1Y54287,14CA56D1A2D5,14CA56D1A2D6,ZTEGD9714A6A$ZTE3ANNQ7L04432,C4EBFF8DEC88,C4EBFF8DEC89,ZTEGD70ACD82$ZTE3ANNR2Q09314,F4E84F818E4C,F4E84F818E4D,ZTEGD97A971C$ZTE3ANNR8C34312,38914851AB37,38914851AB38,ZTEGDB090678', '',0318,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-10-10 08:17:02 Duration: 2s877ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (295034, 433, 'ZTEKH7VP3A10716,D8E8448B996A$ZTEAH7VQ5H00527,6877DA60966B$ZTEAH7VPCD09947,F42D06481473$ZTEAH7VQ6L08329,6877DA62B6AB$ZTEAH7VQ6H01100,6877DA618E6F$ZTEAH7VQ5H00675,6877DA6098BB$ZTEAH7VQ2V15958,6877DA5CDC37$ZTEAH7VQ6H04741,6877DA61C753$ZTEAH7VQA314833,802D1A2081C0$ZTEKH7VP3A10746,D8E8448B99E2$ZTEAH7VQ3L11885,6877DA5F69C3$ZTEAH7VQA300612,802D1A1FA38C$ZTEAH7VQ3L01240,6877DA5EC36F$ZTEAH7VQ3L11441,6877DA5F62D3$ZTEKH7VP2P05863,CC29BDED6A01$ZTEKH7VP3A10725,D8E8448B998E$ZTEAH7VQ8P19576,802D1A1F8D1C$ZTEAH7VPCD04249,F42D0647BB6B$ZTEKH7VP3A10736,D8E8448B99BA$ZTEAH7VQ3L08283,6877DA5F317B$ZTEKH7VP3A10726,D8E8448B9992$ZTEAH7VQ3L08040,6877DA5F2DAF$ZTEAH7VQ3L01038,6877DA5EC047$ZTEAH7VQ3L01166,6877DA5EC247$ZTEAH7VQAQ26482,203AEBA722B6$ZTEAH7VQ3L04614,6877DA5EF827$ZTEAH7VPBU18207,F42D0645C803$ZTEAH7VQ8P12076,802D1A1F17EC$ZTEAH7VPCD03840,F42D0647B507$ZTEAH7VQ3L11660,6877DA5F663F$ZTEKH7VP3A10721,D8E8448B997E$ZTEAH7VQ3L04091,6877DA5EEFFB$ZTEAH7VQ5H00489,6877DA6095D3$ZTEKH7VP3A10749,D8E8448B99EE', '',0301,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-10-10 08:08:08 Duration: 2s113ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (295053, 404, 'C492D945B9A3,ZTE3A8TT7P06931DB36,ZTE3A8TT4X13213$C492D945BCAF,ZTE3A8TT7P07126F176,ZTE3A8TT4723753,ZTE3A8TT3R18705$C492D945B92B,ZTE3A8TT7P06901F01E,ZTE3A8TT4723667$DC5193D8F186,ZTE3A8TQCH06560$C492D945BACB,ZTE3A8TT7P07005$C492D945BABF,ZTE3A8TT7P07002C7D21EEFABF,ZTE3A8TRCP14035$E44E12B2432D,ZTE3A8TR7922407$E44E12B243A9,ZTE3A8TR7922438DD16,ZTE3A8TT3R15181C7D21F20AC3,ZTE3A8TT2L13212C7D21EE51D3,ZTE3A8TRCP03224DDE2,ZTE3A8TT3R15232$DC5193D8F06A,ZTE3A8TQCH06489$E44E12B209D9,ZTE3A8TR7918738A42,ZTE3A8TT3R10904E376,ZTE3A8TT4722857A09E6,ZTE3A8TT4X16201$C492D945BF13,ZTE3A8TT7P07279$E44E12B212BD,ZTE3A8TR7919307$B47CA609970A,ZTE3A8TR8U31130$C492D945BEFB,ZTE3A8TT7P07273$E44E12B2156D,ZTE3A8TR7919479C7D21F01B73,ZTE3A8TRCS07012C7D21ECD8A7,ZTE3A8TRCB04585C7D21ED80AF,ZTE3A8TRCB15339', '',0461,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-10-10 09:17:38 Duration: 1s919ms Database: rio User: intelifix Remote: [local] Application: [unknown]
3 53 41s568ms 566ms 980ms 784ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 10 08 3 2s279ms 759ms 09 4 3s105ms 776ms 10 3 2s394ms 798ms 11 4 2s933ms 733ms 12 3 2s243ms 747ms 13 3 2s341ms 780ms 14 3 2s297ms 765ms 15 4 2s997ms 749ms 16 4 3s136ms 784ms 17 4 3s390ms 847ms 18 4 3s127ms 781ms 19 3 2s488ms 829ms 20 4 3s186ms 796ms 21 4 3s234ms 808ms 22 3 2s411ms 803ms [ User: intelifix - Total duration: 41s568ms - Times executed: 53 ]
[ Application: psql - Total duration: 41s568ms - Times executed: 53 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-10 17:20:02 Duration: 980ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-10 09:00:03 Duration: 970ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-10 08:00:05 Duration: 950ms Database: brasilia User: intelifix Remote: [local] Application: psql
4 48 1h33m30s 2s342ms 6m55s 1m56s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 10 07 3 7m30s 2m30s 08 3 5m45s 1m55s 09 3 5m38s 1m52s 10 3 5m38s 1m52s 11 3 5m40s 1m53s 12 3 5m41s 1m53s 13 3 5m32s 1m50s 14 3 5m36s 1m52s 15 3 5m35s 1m51s 16 3 5m31s 1m50s 17 3 5m36s 1m52s 18 3 5m31s 1m50s 19 3 5m35s 1m51s 20 3 6m42s 2m14s 21 3 6m19s 2m6s 22 3 5m34s 1m51s [ User: intelifix - Total duration: 1h33m30s - Times executed: 48 ]
[ Application: psql - Total duration: 1h33m30s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-10 07:11:57 Duration: 6m55s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-10 20:11:17 Duration: 6m16s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-10 21:11:03 Duration: 6m1s Database: rio User: intelifix Remote: [local] Application: psql
5 47 1h2m47s 230ms 3m33s 1m20s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 10 07 3 4m39s 1m33s 08 3 3m48s 1m16s 09 3 3m47s 1m15s 10 3 3m47s 1m15s 11 3 3m52s 1m17s 12 3 3m59s 1m19s 13 3 3m48s 1m16s 14 3 3m48s 1m16s 15 3 3m50s 1m16s 16 3 3m46s 1m15s 17 3 3m48s 1m16s 18 3 3m46s 1m15s 19 3 3m51s 1m17s 20 2 4m22s 2m11s 21 3 3m48s 1m16s 22 3 4m3s 1m21s [ User: intelifix - Total duration: 1h2m47s - Times executed: 47 ]
[ Application: psql - Total duration: 1h2m47s - Times executed: 47 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-10 22:14:36 Duration: 3m33s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-10 07:17:03 Duration: 3m31s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-10 12:14:40 Duration: 3m27s Database: brasilia User: intelifix Remote: [local] Application: psql
6 37 32s524ms 592ms 2s904ms 879ms call rs_tcia_processa_lotes () / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 10 08 3 4s570ms 1s523ms 09 2 1s603ms 801ms 10 3 2s274ms 758ms 11 2 1s682ms 841ms 12 3 2s274ms 758ms 13 3 2s342ms 780ms 14 3 2s495ms 831ms 15 2 1s641ms 820ms 16 2 1s472ms 736ms 17 2 1s494ms 747ms 18 2 1s690ms 845ms 19 3 2s511ms 837ms 20 2 2s295ms 1s147ms 21 2 1s618ms 809ms 22 3 2s555ms 851ms [ User: intelifix - Total duration: 32s524ms - Times executed: 37 ]
[ Application: psql - Total duration: 32s524ms - Times executed: 37 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-10-10 08:00:04 Duration: 2s904ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-10-10 20:20:02 Duration: 1s521ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-10-10 22:40:02 Duration: 959ms Database: rio User: intelifix Remote: [local] Application: psql
7 34 1m52s 407ms 20s999ms 3s300ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Oct 10 00 6 33s766ms 5s627ms 01 6 16s25ms 2s670ms 02 6 12s28ms 2s4ms 03 5 13s33ms 2s606ms 04 6 23s52ms 3s842ms 05 5 14s300ms 2s860ms [ User: intelifix - Total duration: 1m52s - Times executed: 34 ]
[ Application: psql - Total duration: 1m52s - Times executed: 34 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-10 00:05:22 Duration: 20s999ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-10 04:45:07 Duration: 5s816ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-10 05:25:06 Duration: 5s745ms Database: rio User: intelifix Remote: [local] Application: psql
8 32 34s970ms 267ms 22s835ms 1s92ms create table temp0000293914 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Oct 10 07 6 27s146ms 4s524ms 08 7 2s9ms 287ms 09 8 2s443ms 305ms 10 11 3s370ms 306ms [ User: intelifix - Total duration: 34s970ms - Times executed: 32 ]
[ Application: [unknown] - Total duration: 34s970ms - Times executed: 32 ]
-
CREATE TABLE temp0000293914 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"05-10-2026", "ate" :"10-10-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-10-10 07:04:46 Duration: 22s835ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293914 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"05-10-2026", "ate" :"10-10-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-10-10 07:04:52 Duration: 3s147ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293914 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"05-10-2026", "ate" :"10-10-2026", "nota-fiscal":"85665", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-10-10 07:10:19 Duration: 335ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 22 12s542ms 273ms 3s260ms 570ms create table temp0000293926 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Oct 10 07 3 3s755ms 1s251ms 08 5 4s393ms 878ms 09 8 2s383ms 297ms 10 4 1s367ms 341ms 11 2 641ms 320ms [ User: intelifix - Total duration: 12s542ms - Times executed: 22 ]
[ Application: [unknown] - Total duration: 12s542ms - Times executed: 22 ]
-
CREATE TABLE temp0000293926 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"05-10-2026", "ate" :"10-10-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-10-10 08:54:33 Duration: 3s260ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293926 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"05-10-2026", "ate" :"10-10-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-10-10 07:34:03 Duration: 3s200ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293926 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"05-10-2026", "ate" :"10-10-2026", "nota-fiscal":"85665", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-10-10 10:19:01 Duration: 430ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 20 6s208ms 298ms 348ms 310ms 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 Oct 10 00 1 304ms 304ms 07 5 1s548ms 309ms 08 4 1s265ms 316ms 09 1 298ms 298ms 10 2 623ms 311ms 11 2 621ms 310ms 12 1 310ms 310ms 13 2 604ms 302ms 14 1 311ms 311ms 15 1 320ms 320ms [ User: lenon - Total duration: 6s208ms - Times executed: 20 ]
[ Application: [unknown] - Total duration: 6s208ms - Times executed: 20 ]
-
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-10-10 08:59:21 Duration: 348ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-10-10 15:45:44 Duration: 320ms Database: brasilia User: lenon Remote: [local] Application: [unknown] Bind query: yes
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-10-10 07:27:47 Duration: 319ms Database: brasilia User: lenon Remote: [local] Application: [unknown] Bind query: yes
11 13 5s261ms 151ms 3s265ms 404ms create table temp0000293934 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 10 11 13 5s261ms 404ms [ User: intelifix - Total duration: 5s261ms - Times executed: 13 ]
[ Application: [unknown] - Total duration: 5s261ms - Times executed: 13 ]
-
CREATE TABLE temp0000293934 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"05-10-2026", "ate" :"10-10-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-10-10 11:30:13 Duration: 3s265ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293934 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"05-10-2026", "ate" :"10-10-2026", "nota-fiscal":"727272", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-10-10 11:44:30 Duration: 216ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293934 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"05-10-2026", "ate" :"10-10-2026", "nota-fiscal":"151515", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-10-10 11:36:38 Duration: 183ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 13 2s747ms 187ms 254ms 211ms call rs_giga_triagem (?) / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 10 13 1 187ms 187ms 14 2 391ms 195ms 15 1 188ms 188ms 16 1 210ms 210ms 17 1 207ms 207ms 18 2 433ms 216ms 19 1 206ms 206ms 20 1 203ms 203ms 21 2 467ms 233ms 22 1 252ms 252ms [ User: intelifix - Total duration: 2s747ms - Times executed: 13 ]
[ Application: psql - Total duration: 2s747ms - Times executed: 13 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR') / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-10-10 21:55:05 Duration: 254ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR') / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-10-10 22:35:05 Duration: 252ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR') / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-10-10 18:35:05 Duration: 244ms Database: brasilia User: intelifix Remote: [local] Application: psql
13 10 3s569ms 330ms 409ms 356ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 10 07 2 719ms 359ms 08 3 1s106ms 368ms 09 1 330ms 330ms 10 2 718ms 359ms 11 2 693ms 346ms [ User: intelifix - Total duration: 3s569ms - Times executed: 10 ]
[ Application: [unknown] - Total duration: 3s569ms - Times executed: 10 ]
-
select * from rs_menu_grants (404, 18, 1);
Date: 2026-10-10 08:59:21 Duration: 409ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (404, 18, 1);
Date: 2026-10-10 10:18:04 Duration: 376ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (433, 18, 1);
Date: 2026-10-10 07:35:02 Duration: 368ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 9 5s482ms 270ms 3s210ms 609ms create table temp0000293922 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Oct 10 07 4 4s55ms 1s13ms 08 5 1s427ms 285ms [ User: intelifix - Total duration: 5s482ms - Times executed: 9 ]
[ Application: [unknown] - Total duration: 5s482ms - Times executed: 9 ]
-
CREATE TABLE temp0000293922 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"05-10-2026", "ate" :"10-10-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-10-10 07:34:57 Duration: 3s210ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293922 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"05-10-2026", "ate" :"10-10-2026", "nota-fiscal":"85665", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-10-10 08:22:48 Duration: 301ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293922 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"05-10-2026", "ate" :"10-10-2026", "nota-fiscal":"85665", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-10-10 07:35:02 Duration: 296ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 9 3s714ms 360ms 527ms 412ms select * from rs_menu (?, ?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 10 00 1 527ms 527ms 07 3 1s259ms 419ms 08 1 427ms 427ms 12 1 373ms 373ms 13 1 373ms 373ms 14 1 372ms 372ms 15 1 381ms 381ms [ User: intelifix - Total duration: 3s714ms - Times executed: 9 ]
[ Application: [unknown] - Total duration: 3s714ms - Times executed: 9 ]
-
SELECT * FROM RS_MENU (319, 1);
Date: 2026-10-10 00:47:38 Duration: 527ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_MENU (401, 1);
Date: 2026-10-10 07:27:47 Duration: 498ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_MENU (399, 1);
Date: 2026-10-10 08:41:13 Duration: 427ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
16 8 12s942ms 295ms 4s522ms 1s617ms select * from rs_auditor_novas_tabelas ();Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 10 00 4 7s423ms 1s855ms 06 4 5s518ms 1s379ms [ User: lenon - Total duration: 12s942ms - Times executed: 8 ]
[ Application: psql - Total duration: 12s942ms - Times executed: 8 ]
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-10-10 00:02:06 Duration: 4s522ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-10-10 06:02:04 Duration: 2s817ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-10-10 00:02:08 Duration: 1s935ms Database: brasilia User: lenon Remote: [local] Application: psql
17 7 1m41s 10s551ms 35s490ms 14s454ms create table temp0000293928 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Oct 10 07 7 1m41s 14s454ms [ User: intelifix - Total duration: 1m41s - Times executed: 7 ]
[ Application: [unknown] - Total duration: 1m41s - Times executed: 7 ]
-
CREATE TABLE temp0000293928 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-10 07:36:23 Duration: 35s490ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293928 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-10 07:41:52 Duration: 11s268ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293928 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-10 07:41:32 Duration: 11s123ms Database: rio User: intelifix Remote: [local] Application: [unknown]
18 6 1m48s 3s276ms 40s281ms 18s44ms copy public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 10 20 3 54s119ms 18s39ms 23 3 54s147ms 18s49ms [ User: intelifix - Total duration: 1m48s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m48s - Times executed: 6 ]
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-10-10 20:06:26 Duration: 40s281ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-10-10 23:14:26 Duration: 40s109ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-10-10 23:33:32 Duration: 10s583ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
19 6 1m23s 2s292ms 31s898ms 13s988ms copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 10 20 3 41s985ms 13s995ms 23 3 41s944ms 13s981ms [ User: intelifix - Total duration: 1m23s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m23s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-10-10 20:07:00 Duration: 31s898ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-10-10 23:15:01 Duration: 31s767ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-10-10 23:33:40 Duration: 7s878ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
20 6 1m23s 3s51ms 32s566ms 13s974ms copy public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 10 20 3 41s715ms 13s905ms 23 3 42s133ms 14s44ms [ User: intelifix - Total duration: 1m23s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m23s - Times executed: 6 ]
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-10-10 23:17:13 Duration: 32s566ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-10-10 20:09:12 Duration: 32s108ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-10-10 20:10:44 Duration: 6s556ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 2m39s 9m31s 6m18s 3 18m56s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 10 05 3 18m56s 6m18s [ User: intelifix - Total duration: 18m56s - Times executed: 3 ]
[ Application: psql - Total duration: 18m56s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-10-10 05:09:32 Duration: 9m31s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-10-10 05:16:17 Duration: 6m45s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-10-10 05:18:57 Duration: 2m39s Database: contagem User: intelifix Remote: [local] Application: psql
2 2s342ms 6m55s 1m56s 48 1h33m30s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 10 07 3 7m30s 2m30s 08 3 5m45s 1m55s 09 3 5m38s 1m52s 10 3 5m38s 1m52s 11 3 5m40s 1m53s 12 3 5m41s 1m53s 13 3 5m32s 1m50s 14 3 5m36s 1m52s 15 3 5m35s 1m51s 16 3 5m31s 1m50s 17 3 5m36s 1m52s 18 3 5m31s 1m50s 19 3 5m35s 1m51s 20 3 6m42s 2m14s 21 3 6m19s 2m6s 22 3 5m34s 1m51s [ User: intelifix - Total duration: 1h33m30s - Times executed: 48 ]
[ Application: psql - Total duration: 1h33m30s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-10 07:11:57 Duration: 6m55s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-10 20:11:17 Duration: 6m16s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-10 21:11:03 Duration: 6m1s Database: rio User: intelifix Remote: [local] Application: psql
3 1m24s 1m24s 1m24s 1 1m24s refresh materialized view concurrently rs_mv_codigos_barra;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 10 05 1 1m24s 1m24s [ User: intelifix - Total duration: 1m24s - Times executed: 1 ]
[ Application: psql - Total duration: 1m24s - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-10-10 05:32:05 Duration: 1m24s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-10-10 05:31:56 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
4 230ms 3m33s 1m20s 47 1h2m47s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 10 07 3 4m39s 1m33s 08 3 3m48s 1m16s 09 3 3m47s 1m15s 10 3 3m47s 1m15s 11 3 3m52s 1m17s 12 3 3m59s 1m19s 13 3 3m48s 1m16s 14 3 3m48s 1m16s 15 3 3m50s 1m16s 16 3 3m46s 1m15s 17 3 3m48s 1m16s 18 3 3m46s 1m15s 19 3 3m51s 1m17s 20 2 4m22s 2m11s 21 3 3m48s 1m16s 22 3 4m3s 1m21s [ User: intelifix - Total duration: 1h2m47s - Times executed: 47 ]
[ Application: psql - Total duration: 1h2m47s - Times executed: 47 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-10 22:14:36 Duration: 3m33s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-10 07:17:03 Duration: 3m31s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-10 12:14:40 Duration: 3m27s Database: brasilia User: intelifix Remote: [local] Application: psql
5 4s342ms 1m2s 33s521ms 4 2m14s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 10 20 2 1m6s 33s488ms 23 2 1m7s 33s554ms [ User: intelifix - Total duration: 2m14s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m14s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-10-10 23:16:40 Duration: 1m2s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-10-10 20:08:39 Duration: 1m2s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-10-10 23:33:56 Duration: 4s343ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
6 365ms 53s489ms 26s801ms 4 1m47s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 10 20 2 53s866ms 26s933ms 23 2 53s341ms 26s670ms [ User: intelifix - Total duration: 1m47s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m47s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-10-10 20:05:44 Duration: 53s489ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-10-10 23:13:44 Duration: 52s976ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-10-10 20:10:03 Duration: 376ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
7 3s276ms 40s281ms 18s44ms 6 1m48s copy public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Oct 10 20 3 54s119ms 18s39ms 23 3 54s147ms 18s49ms [ User: intelifix - Total duration: 1m48s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m48s - Times executed: 6 ]
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-10-10 20:06:26 Duration: 40s281ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-10-10 23:14:26 Duration: 40s109ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-10-10 23:33:32 Duration: 10s583ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
8 10s551ms 35s490ms 14s454ms 7 1m41s create table temp0000293928 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Oct 10 07 7 1m41s 14s454ms [ User: intelifix - Total duration: 1m41s - Times executed: 7 ]
[ Application: [unknown] - Total duration: 1m41s - Times executed: 7 ]
-
CREATE TABLE temp0000293928 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-10 07:36:23 Duration: 35s490ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293928 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-10 07:41:52 Duration: 11s268ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293928 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-10 07:41:32 Duration: 11s123ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 2s292ms 31s898ms 13s988ms 6 1m23s copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Oct 10 20 3 41s985ms 13s995ms 23 3 41s944ms 13s981ms [ User: intelifix - Total duration: 1m23s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m23s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-10-10 20:07:00 Duration: 31s898ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-10-10 23:15:01 Duration: 31s767ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-10-10 23:33:40 Duration: 7s878ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
10 3s51ms 32s566ms 13s974ms 6 1m23s copy public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Oct 10 20 3 41s715ms 13s905ms 23 3 42s133ms 14s44ms [ User: intelifix - Total duration: 1m23s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m23s - Times executed: 6 ]
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-10-10 23:17:13 Duration: 32s566ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-10-10 20:09:12 Duration: 32s108ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-10-10 20:10:44 Duration: 6s556ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
11 4s271ms 23s746ms 13s966ms 4 55s865ms copy public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 10 20 2 27s846ms 13s923ms 23 2 28s19ms 14s9ms [ User: intelifix - Total duration: 55s865ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 55s865ms - Times executed: 4 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-10-10 23:12:51 Duration: 23s746ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-10-10 20:04:50 Duration: 23s574ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-10-10 23:33:21 Duration: 4s273ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
12 2s533ms 23s655ms 11s960ms 6 1m11s copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 10 20 3 35s863ms 11s954ms 23 3 35s901ms 11s967ms [ User: intelifix - Total duration: 1m11s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m11s - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-10-10 20:02:46 Duration: 23s655ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-10-10 23:10:47 Duration: 23s483ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-10-10 23:32:49 Duration: 9s850ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
13 2s232ms 24s216ms 11s873ms 6 1m11s copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 10 20 3 35s688ms 11s896ms 23 3 35s551ms 11s850ms [ User: intelifix - Total duration: 1m11s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m11s - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-10-10 20:03:27 Duration: 24s216ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-10-10 23:11:28 Duration: 24s134ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-10-10 20:09:43 Duration: 9s239ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
14 1s692ms 25s374ms 10s717ms 6 1m4s copy public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Oct 10 20 3 32s52ms 10s684ms 23 3 32s254ms 10s751ms [ User: intelifix - Total duration: 1m4s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m4s - Times executed: 6 ]
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-10-10 23:12:27 Duration: 25s374ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-10-10 20:04:26 Duration: 25s365ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-10-10 23:33:16 Duration: 5s112ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
15 5s979ms 13s43ms 9s253ms 6 55s520ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 10 00 3 32s763ms 10s921ms 06 3 22s756ms 7s585ms [ User: intelifix - Total duration: 55s520ms - Times executed: 6 ]
[ Application: psql - Total duration: 55s520ms - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-10-10 00:05:25 Duration: 13s43ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-10-10 00:05:12 Duration: 10s557ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-10-10 06:05:18 Duration: 9s666ms Database: brasilia User: intelifix Remote: [local] Application: psql
16 1s832ms 16s840ms 8s624ms 6 51s749ms copy public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 10 20 3 25s822ms 8s607ms 23 3 25s926ms 8s642ms [ User: intelifix - Total duration: 51s749ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 51s749ms - Times executed: 6 ]
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-10-10 20:03:44 Duration: 16s840ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-10-10 23:11:45 Duration: 16s710ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-10-10 23:33:09 Duration: 7s361ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
17 407ms 20s999ms 3s300ms 34 1m52s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Oct 10 00 6 33s766ms 5s627ms 01 6 16s25ms 2s670ms 02 6 12s28ms 2s4ms 03 5 13s33ms 2s606ms 04 6 23s52ms 3s842ms 05 5 14s300ms 2s860ms [ User: intelifix - Total duration: 1m52s - Times executed: 34 ]
[ Application: psql - Total duration: 1m52s - Times executed: 34 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-10 00:05:22 Duration: 20s999ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-10 04:45:07 Duration: 5s816ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-10 05:25:06 Duration: 5s745ms Database: rio User: intelifix Remote: [local] Application: psql
18 184ms 8s443ms 2s163ms 263 9m28s call rs_giga_triagem (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 10 00 12 29s582ms 2s465ms 01 12 23s511ms 1s959ms 02 12 23s812ms 1s984ms 03 12 23s795ms 1s982ms 04 12 23s876ms 1s989ms 05 12 23s883ms 1s990ms 06 12 24s207ms 2s17ms 07 12 24s268ms 2s22ms 08 12 24s208ms 2s17ms 09 12 24s919ms 2s76ms 10 12 24s706ms 2s58ms 11 12 23s839ms 1s986ms 12 12 24s157ms 2s13ms 13 11 23s816ms 2s165ms 14 10 24s62ms 2s406ms 15 11 23s513ms 2s137ms 16 11 23s896ms 2s172ms 17 11 24s438ms 2s221ms 18 10 23s924ms 2s392ms 19 11 24s194ms 2s199ms 20 11 34s533ms 3s139ms 21 10 23s706ms 2s370ms 22 11 24s69ms 2s188ms [ User: intelifix - Total duration: 9m28s - Times executed: 263 ]
[ Application: psql - Total duration: 9m28s - Times executed: 263 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-10 20:05:09 Duration: 8s443ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-10 00:05:30 Duration: 7s892ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-10 20:15:08 Duration: 7s284ms Database: rio User: intelifix Remote: [local] Application: psql
19 295ms 4s522ms 1s617ms 8 12s942ms select * from rs_auditor_novas_tabelas ();Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 10 00 4 7s423ms 1s855ms 06 4 5s518ms 1s379ms [ User: lenon - Total duration: 12s942ms - Times executed: 8 ]
[ Application: psql - Total duration: 12s942ms - Times executed: 8 ]
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-10-10 00:02:06 Duration: 4s522ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-10-10 06:02:04 Duration: 2s817ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-10-10 00:02:08 Duration: 1s935ms Database: brasilia User: lenon Remote: [local] Application: psql
20 267ms 22s835ms 1s92ms 32 34s970ms create table temp0000293914 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 10 07 6 27s146ms 4s524ms 08 7 2s9ms 287ms 09 8 2s443ms 305ms 10 11 3s370ms 306ms [ User: intelifix - Total duration: 34s970ms - Times executed: 32 ]
[ Application: [unknown] - Total duration: 34s970ms - Times executed: 32 ]
-
CREATE TABLE temp0000293914 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"05-10-2026", "ate" :"10-10-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-10-10 07:04:46 Duration: 22s835ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293914 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"05-10-2026", "ate" :"10-10-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-10-10 07:04:52 Duration: 3s147ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293914 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"05-10-2026", "ate" :"10-10-2026", "nota-fiscal":"85665", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-10-10 07:10:19 Duration: 335ms Database: rio User: intelifix Remote: [local] Application: [unknown]
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 8 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Oct 10 09 1 0ms 0ms 11 1 0ms 0ms 16 1 0ms 0ms 17 2 0ms 0ms 18 1 0ms 0ms 21 2 0ms 0ms [ User: intelifix - Total duration: 7m - Times executed: 8 ]
[ Application: psql - Total duration: 7m - Times executed: 8 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 2,513 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 25 FATAL entries
- 7 ERROR entries
- 0 WARNING entries
- 2 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 16 Max number of times the same event was reported
- 34 Total events found
Rank Times reported Error 1 16 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Oct 10 00 3 02 1 03 2 06 2 07 1 12 1 15 2 16 2 19 2 - FATAL: database "jaboatao" does not exist
- FATAL: database "jaboatao" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-10-10 00:09:04 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
Date: 2026-10-10 00:09:19 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
Date: 2026-10-10 00:09:34 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
2 6 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #2
Day Hour Count Oct 10 03 6 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-10-10 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Date: 2026-10-10 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-10-10 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
3 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #3
Day Hour Count Oct 10 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-10-10 05:32:05 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-10-10 05:32:05 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-10-10 05:32:05 Database: contagem Application: psql User: intelifix Remote: [local]
4 3 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #4
Day Hour Count Oct 10 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-10-10 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-10-10 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
Date: 2026-10-10 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
5 2 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #5
Day Hour Count Oct 10 15 2 - ERROR: prepared statement "_PLAN0000000025064690" does not exist
- ERROR: prepared statement "_PLAN00000000256F1830" does not exist
Statement: DEALLOCATE "_PLAN0000000025064690"
Date: 2026-10-10 15:39:35 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN00000000256F1830" /usr/lib/python3.9/site-packages/urllib3/connectionpool.py:1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/latest/advanced-usage.html#ssl-warnings warnings.warn(
Date: 2026-10-10 15:39:36 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
6 1 ERROR: canceling autovacuum task
Times Reported Most Frequent Error / Event #6
Day Hour Count Oct 10 07 1 - ERROR: canceling autovacuum task
Context: automatic vacuum of table "rio.public.temp0000293928"
Date: 2026-10-10 07:36:35
7 1 LOG: process ... still waiting for AccessExclusiveLock on relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #7
Day Hour Count Oct 10 07 1 - LOG: process 2786719 still waiting for AccessExclusiveLock on relation 5971597 of database 358220 after 1000.162 ms
Detail: Process holding the lock: 2787031. Wait queue: 2786719.
Statement: DROP TABLE IF EXISTS temp0000293928;Date: 2026-10-10 07:36:35 Database: rio Application: [unknown] User: intelifix Remote: [local]
8 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #8
Day Hour Count Oct 10 03 1 - LOG: database system was shut down at 2026-10-10 03:05:01 -03
Date: 2026-10-10 03:05:02