pgBadger-
Global information
- Generated on Tue Sep 8 23:50:19 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 9,028 log entries in 17s
- Log start from 2026-09-07 00:00:06 to 2026-09-07 23:59:47
-
Overview
Global Stats
- 146 Number of unique normalized queries
- 868 Number of queries
- 3h56m5s Total query duration
- 2026-09-07 00:02:09 First query
- 2026-09-07 23:48:44 Last query
- 5 queries/s at 2026-09-07 23:43:04 Query peak
- 3h56m5s Total query duration
- 385ms Prepare/parse total duration
- 0ms Bind total duration
- 3h56m5s Execute total duration
- 1,475 Number of events
- 8 Number of unique normalized events
- 1,428 Max number of times the same event was reported
- 0 Number of cancellation
- 6 Total number of automatic vacuums
- 0 Total number of automatic analyzes
- 20 Number temporary file
- 244.71 MiB Max size of temporary file
- 66.62 MiB Average size of temporary file
- 197 Total number of sessions
- 7 sessions at 2026-09-07 01:05:02 Session peak
- 7d12h35m11s Total duration of sessions
- 55m Average duration of sessions
- 4 Average queries per session
- 1m11s Average queries duration per session
- 53m48s Average idle time per session
- 227 Total number of connections
- 3 connections/s at 2026-09-07 03:05:16 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 5 queries/s Query Peak
- 2026-09-07 23:43:04 Date
SELECT Traffic
Key values
- 3 queries/s Query Peak
- 2026-09-07 23:17:18 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 5 queries/s Query Peak
- 2026-09-07 23:43:04 Date
Queries duration
Key values
- 3h56m5s 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) Sep 07 00 19 0ms 26s345ms 4s952ms 2s751ms 3s12ms 1m8s 01 9 0ms 2s722ms 1s748ms 2s436ms 2s683ms 2s908ms 02 8 0ms 2s783ms 1s976ms 2s441ms 2s686ms 2s803ms 03 9 0ms 2s637ms 1s476ms 526ms 2s485ms 2s816ms 04 7 0ms 2s507ms 2s116ms 2s373ms 2s472ms 2s612ms 05 13 0ms 10m38s 1m43s 2s805ms 2m51s 10m38s 06 14 0ms 9s918ms 3s469ms 2s532ms 2s979ms 26s584ms 07 14 0ms 9m49s 1m11s 2s681ms 1m54s 9m49s 08 19 0ms 4m45s 29s436ms 2s684ms 41s728ms 4m45s 09 19 0ms 4m45s 29s291ms 2s568ms 41s657ms 4m45s 10 21 0ms 4m43s 26s313ms 2s800ms 41s554ms 4m43s 11 19 0ms 4m45s 29s142ms 2s569ms 41s862ms 4m45s 12 20 0ms 4m59s 29s250ms 2s784ms 3s366ms 5m43s 13 20 0ms 5m3s 29s554ms 2s636ms 3s52ms 5m49s 14 20 0ms 5m2s 29s455ms 2s587ms 2s923ms 5m46s 15 21 0ms 4m57s 27s813ms 2s861ms 43s316ms 4m57s 16 21 0ms 4m56s 27s702ms 2s906ms 44s265ms 4m56s 17 20 0ms 4m59s 29s139ms 2s704ms 2s988ms 5m43s 18 23 0ms 4m57s 25s441ms 2s875ms 43s645ms 4m57s 19 20 0ms 4m54s 28s828ms 2s718ms 43s647ms 4m54s 20 123 0ms 7m50s 11s795ms 1m7s 1m46s 7m50s 21 23 0ms 6m39s 29s725ms 3s161ms 43s865ms 6m39s 22 22 0ms 5m 26s647ms 2s825ms 2s992ms 5m44s 23 364 0ms 1m3s 5s487ms 1m4s 1m6s 1m11s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 07 00 3 0 3s937ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 1 0 182ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 3 0 2s884ms 0ms 0ms 0ms 07 6 0 2m45s 0ms 0ms 4m6s 08 6 0 1m28s 0ms 0ms 3m25s 09 6 0 1m29s 0ms 0ms 3m29s 10 6 0 1m28s 0ms 0ms 3m25s 11 6 0 1m28s 0ms 0ms 3m25s 12 6 0 1m33s 0ms 0ms 3m39s 13 6 0 1m34s 0ms 0ms 3m39s 14 6 0 1m34s 0ms 0ms 3m41s 15 6 0 1m33s 0ms 0ms 3m40s 16 6 0 1m33s 0ms 0ms 3m39s 17 6 0 1m33s 0ms 0ms 3m38s 18 9 0 1m2s 0ms 0ms 3m40s 19 6 0 1m32s 0ms 0ms 3m36s 20 23 79 13s655ms 41s768ms 1m3s 3m56s 21 7 0 1m34s 0ms 0ms 3m37s 22 6 0 1m34s 0ms 0ms 3m39s 23 41 322 5s502ms 1m1s 1m4s 1m7s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 07 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Sep 07 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 1 1.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.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 1 1 1.00 0.98% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 1 6 6.00 0.28% Day Hour Count Average / Second Sep 07 00 17 0.00/s 01 7 0.00/s 02 7 0.00/s 03 12 0.00/s 04 10 0.00/s 05 10 0.00/s 06 14 0.00/s 07 9 0.00/s 08 8 0.00/s 09 11 0.00/s 10 7 0.00/s 11 7 0.00/s 12 8 0.00/s 13 6 0.00/s 14 8 0.00/s 15 9 0.00/s 16 7 0.00/s 17 7 0.00/s 18 17 0.00/s 19 7 0.00/s 20 11 0.00/s 21 13 0.00/s 22 7 0.00/s 23 8 0.00/s Day Hour Count Average Duration Average idle time Sep 07 00 4 47m30s 47m6s 01 13 1h1m9s 1h1m8s 02 7 1h25s 1h23s 03 12 24m49s 24m47s 04 7 1h2m34s 1h2m32s 05 7 1h 56m49s 06 7 56m28s 56m21s 07 13 1h49s 59m32s 08 8 56m15s 55m5s 09 7 57m8s 55m49s 10 7 1h2m40s 1h1m21s 11 7 1h 58m41s 12 7 1h43s 59m19s 13 8 1h23s 59m9s 14 6 1h53s 59m14s 15 8 1h49s 59m36s 16 8 1h58s 59m46s 17 7 1h 58m37s 18 8 53m45s 52m32s 19 8 1h51s 59m39s 20 10 42m57s 40m32s 21 8 1h1m 59m34s 22 7 1h 58m37s 23 13 34m52s 32m19s -
Connections
Established Connections
Key values
- 3 connections Connection Peak
- 2026-09-07 03:05:16 Date
Connections per database
Key values
- rio Main Database
- 227 connections Total
Connections per user
Key values
- intelifix Main User
- 227 connections Total
-
Sessions
Simultaneous sessions
Key values
- 7 sessions Session Peak
- 2026-09-07 01:05:02 Date
Histogram of session times
Key values
- 171 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 197 sessions Total
Sessions per user
Key values
- intelifix Main User
- 197 sessions Total
Sessions per host
Key values
- [local] Main Host
- 197 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 10,206 buffers Checkpoint Peak
- 2026-09-07 00:09:55 Date
- 269.048 seconds Highest write time
- 0.274 seconds Sync time
Checkpoints Wal files
Key values
- 3 files Wal files usage Peak
- 2026-09-07 00:09:55 Date
Checkpoints distance
Key values
- 108.16 Mo Distance Peak
- 2026-09-07 00:09:55 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Sep 07 00 10,206 269.048s 0.062s 269.115s 01 0 0s 0s 0s 02 0 0s 0s 0s 03 5,056 0.114s 0.276s 0.413s 04 0 0s 0s 0s 05 7,364 737.345s 0.094s 737.467s 06 1,553 155.28s 0.002s 155.286s 07 734 73.565s 0.012s 73.581s 08 24 2.418s 0.006s 2.429s 09 25 2.519s 0.007s 2.533s 10 24 2.42s 0.012s 2.449s 11 24 2.419s 0.006s 2.431s 12 24 2.419s 0.005s 2.43s 13 24 2.421s 0.015s 2.445s 14 25 2.521s 0.011s 2.539s 15 25 2.52s 0.005s 2.532s 16 25 2.521s 0.064s 2.592s 17 24 2.42s 0.005s 2.43s 18 541 54.26s 0.036s 54.368s 19 24 2.418s 0.005s 2.43s 20 24 2.426s 0.008s 2.443s 21 23 2.312s 0.063s 2.381s 22 25 2.52s 0.066s 2.613s 23 23 2.31s 0.002s 2.325s Day Hour Added Removed Recycled Synced files Longest sync Average sync Sep 07 00 0 0 3 34 0.061s 0.002s 01 0 0 0 0 0s 0s 02 0 0 0 0 0s 0s 03 0 0 2 16 0.261s 0.023s 04 0 0 0 0 0s 0s 05 0 0 3 136 0.064s 0.01s 06 0 0 0 10 0.002s 0.001s 07 0 0 1 14 0.007s 0.001s 08 0 0 0 5 0.002s 0.003s 09 0 0 0 5 0.002s 0.004s 10 0 0 0 5 0.007s 0.006s 11 0 0 0 5 0.002s 0.003s 12 0 0 0 5 0.002s 0.002s 13 0 0 0 5 0.011s 0.007s 14 0 0 0 5 0.006s 0.006s 15 0 0 0 5 0.002s 0.002s 16 0 0 0 5 0.061s 0.022s 17 0 0 0 5 0.002s 0.002s 18 0 0 0 58 0.008s 0.008s 19 0 0 0 5 0.002s 0.002s 20 0 0 0 10 0.003s 0.003s 21 0 0 0 3 0.062s 0.021s 22 0 0 0 5 0.062s 0.023s 23 0 0 0 1 0.002s 0.002s Day Hour Count Avg time (sec) Sep 07 00 0 0s 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s 23 0 0s Day Hour Mean distance Mean estimate Sep 07 00 55,380.00 kB 55,380.00 kB 01 0.00 kB 0.00 kB 02 0.00 kB 0.00 kB 03 14,724.50 kB 26,393.50 kB 04 0.00 kB 0.00 kB 05 7,345.57 kB 10,550.43 kB 06 3,608.00 kB 11,381.00 kB 07 6,641.00 kB 10,907.00 kB 08 94.50 kB 9,341.00 kB 09 95.00 kB 7,584.50 kB 10 94.50 kB 6,162.50 kB 11 95.00 kB 5,009.00 kB 12 94.50 kB 4,071.50 kB 13 95.00 kB 3,314.50 kB 14 95.00 kB 2,703.50 kB 15 94.50 kB 2,209.50 kB 16 95.00 kB 1,808.50 kB 17 94.50 kB 1,483.00 kB 18 513.00 kB 1,531.00 kB 19 95.00 kB 1,140.00 kB 20 263.00 kB 919.67 kB 21 188.00 kB 796.00 kB 22 95.00 kB 696.00 kB 23 77.00 kB 604.00 kB -
Temporary Files
Size of temporary files
Key values
- 489.42 MiB Temp Files size Peak
- 2026-09-07 05:31:52 Date
Number of temporary files
Key values
- 4 per second Temp Files Peak
- 2026-09-07 05:31:58 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Sep 07 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 20 1.30 GiB 66.62 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.00 GiB 36.49 MiB 244.71 MiB 64.23 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-07 05:32:01 Duration: 1m20s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-07 05:31:52 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 4 304.66 MiB 56.62 MiB 93.18 MiB 76.16 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-07 05:30:40 Duration: 38s72ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-07 05:30:36 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
Queries generating the largest temporary files
Rank Size Query 1 244.71 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-07 05:31:52 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 244.71 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-07 05:31:52 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 93.18 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-07 05:30:36 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 93.18 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-07 05:30:36 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 61.68 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-07 05:30:39 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 56.62 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-07 05:30:40 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 40.46 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-07 05:32:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 40.40 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-07 05:31:58 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 40.39 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-07 05:31:58 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 40.39 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-07 05:31:57 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 40.38 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-07 05:31:59 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 40.37 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-07 05:31:57 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 40.37 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-07 05:31:59 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 36.56 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-07 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 36.51 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-07 05:31:59 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 36.51 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-07 05:31:58 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 36.50 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-07 05:31:57 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 36.50 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-07 05:32:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 36.49 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-07 05:31:58 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 36.49 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-07 05:31:59 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0.36 sec Highest CPU-cost vacuum
Table pg_catalog.pg_statistic
Database rio - 2026-09-07 05:11:34 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 0.36 sec Highest CPU-cost vacuum
Table pg_catalog.pg_statistic
Database rio - 2026-09-07 05:11:34 Date
Analyzes per table
Key values
- unknown (0) Main table analyzed (database )
- 0 analyzes Total
Vacuums per table
Key values
- pg_catalog.pg_statistic (1) Main table vacuumed on database brasilia
- 6 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples brasilia.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,692 515 2,105,772 476 3,297 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 122 35 107,313 5 10 rio.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 830 230 1,196,502 123 424 rio.pg_catalog.pg_statistic 1 1 0 0 0 0 0 3,621 979 4,177,090 927 5,588 contagem.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,327 925 2,905,259 894 6,435 brasilia.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 159 38 125,976 11 30 Total 6 6 0 0 0 0 0 9,751 2,722 10,617,912 2,436 15,784 Vacuum throughput per table
Key values
- pg_catalog.pg_statistic (0.36) 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
Tuples removed per table
Key values
- pg_catalog.pg_statistic (4501) Main table with removed tuples on database rio
- 13522 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_statistic 1 1 4,501 7,472 0 0 1,286 contagem.pg_catalog.pg_statistic 1 1 4,368 7,274 0 0 1,011 brasilia.pg_catalog.pg_statistic 1 1 3,815 7,360 0 0 1,072 rio.pg_toast.pg_toast_2619 1 1 620 678 0 0 266 brasilia.pg_toast.pg_toast_2619 1 1 116 137 0 13 49 contagem.pg_toast.pg_toast_2619 1 1 102 116 0 0 53 Total 6 6 13,522 23,037 0 13 3,737 Pages removed per table
Key values
- pg_toast.pg_toast_2619 (13) Main table with removed pages on database brasilia
- 13 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed brasilia.pg_toast.pg_toast_2619 1 1 116 13 brasilia.pg_catalog.pg_statistic 1 1 3815 0 contagem.pg_toast.pg_toast_2619 1 1 102 0 rio.pg_toast.pg_toast_2619 1 1 620 0 rio.pg_catalog.pg_statistic 1 1 4501 0 contagem.pg_catalog.pg_statistic 1 1 4368 0 Total 6 6 13,522 13 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Sep 07 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 6 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 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 - 0.36 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- unknown Main Lock Type
- 0 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query NO DATASET
Queries that waited the most
Rank Wait time Query NO DATASET
-
Queries
Queries by type
Key values
- 165 Total read queries
- 401 Total write queries
Queries by database
Key values
- rio Main database
- 403 Requests
- 2h29m27s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 848 Requests
User Request type Count Duration etiquetas Total 14 9s363ms select 14 9s363ms intelifix Total 848 3h55m35s copy to 401 42m6s others 302 31m43s select 145 2h41m45s lenon Total 6 20s468ms select 6 20s468ms Duration by user
Key values
- 3h55m35s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 14 9s363ms select 14 9s363ms intelifix Total 848 3h55m35s copy to 401 42m6s others 302 31m43s select 145 2h41m45s lenon Total 6 20s468ms select 6 20s468ms Queries by host
Key values
- [local] Main host
- 868 Requests
- 3h56m5s ([local])
- Main time consuming host
Queries by application
Key values
- pg_dump Main application
- 447 Requests
- 3h13m35s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-09-07 23:43:25 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 337 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 10m38s analyze verbose;[ Date: 2026-09-07 05:10:40 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 9m49s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-07 07:14:50 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 7m50s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-07 20:12:51 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 6m39s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-07 21:11:40 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 6m36s analyze verbose;[ Date: 2026-09-07 05:17:16 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
6 5m3s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-07 13:10:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 5m2s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-07 14:10:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 5m SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-07 22:10:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 4m59s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-07 12:10:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 4m59s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-07 17:10:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 4m57s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-07 18:09:59 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 4m57s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-07 15:09:58 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 4m56s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-07 16:09:57 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 4m54s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-07 19:09:56 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 4m45s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-07 11:09:47 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 4m45s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-07 09:09:47 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 4m45s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-07 08:09:46 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 4m43s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-07 10:09:45 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 3m56s SELECT * FROM RS_SMART_FISCAL_SAIDA ();[ Date: 2026-09-07 07:21:22 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
20 3m50s SELECT * FROM RS_SMART_FISCAL_SAIDA ();[ Date: 2026-09-07 20:18:53 - 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 1h33m8s 48 1s339ms 9m49s 1m56s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 07 07 3 10m35s 3m31s 08 3 5m 1m40s 09 3 5m 1m40s 10 3 4m58s 1m39s 11 3 5m1s 1m40s 12 3 5m15s 1m45s 13 3 5m20s 1m46s 14 3 5m18s 1m46s 15 3 5m12s 1m44s 16 3 5m12s 1m44s 17 3 5m15s 1m45s 18 3 5m13s 1m44s 19 3 5m10s 1m43s 20 3 8m21s 2m47s 21 3 6m55s 2m18s 22 3 5m15s 1m45s [ User: intelifix - Total duration: 1h33m8s - Times executed: 48 ]
[ Application: psql - Total duration: 1h33m8s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-07 07:14:50 Duration: 9m49s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-07 20:12:51 Duration: 7m50s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-07 21:11:40 Duration: 6m39s Database: rio User: intelifix Remote: [local] Application: psql
2 1h8m20s 48 254ms 3m56s 1m25s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 07 07 3 5m54s 1m58s 08 3 3m51s 1m17s 09 3 3m55s 1m18s 10 3 3m51s 1m17s 11 3 3m52s 1m17s 12 3 4m8s 1m22s 13 3 4m8s 1m22s 14 3 4m9s 1m23s 15 3 4m7s 1m22s 16 3 4m8s 1m22s 17 3 4m6s 1m22s 18 3 4m7s 1m22s 19 3 4m4s 1m21s 20 3 5m39s 1m53s 21 3 4m5s 1m21s 22 3 4m8s 1m22s [ User: intelifix - Total duration: 1h8m20s - Times executed: 48 ]
[ Application: psql - Total duration: 1h8m20s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-07 07:21:22 Duration: 3m56s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-07 20:18:53 Duration: 3m50s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-07 14:14:27 Duration: 3m39s Database: brasilia User: intelifix Remote: [local] Application: psql
3 20m6s 3 2m51s 10m38s 6m42s analyze verbose;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 07 05 3 20m6s 6m42s [ User: intelifix - Total duration: 20m6s - Times executed: 3 ]
[ Application: psql - Total duration: 20m6s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-09-07 05:10:40 Duration: 10m38s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-07 05:17:16 Duration: 6m36s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-07 05:20:08 Duration: 2m51s Database: contagem User: intelifix Remote: [local] Application: psql
4 7m12s 191 150ms 26s345ms 2s264ms call rs_giga_triagem (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 07 00 9 45s913ms 5s101ms 01 9 15s737ms 1s748ms 02 8 15s814ms 1s976ms 03 8 13s109ms 1s638ms 04 7 14s812ms 2s116ms 05 8 15s720ms 1s965ms 06 8 15s904ms 1s988ms 07 8 15s614ms 1s951ms 08 7 15s858ms 2s265ms 09 7 15s613ms 2s230ms 10 9 16s43ms 1s782ms 11 7 15s575ms 2s225ms 12 8 17s391ms 2s173ms 13 8 16s533ms 2s66ms 14 8 16s151ms 2s18ms 15 9 16s463ms 1s829ms 16 9 16s962ms 1s884ms 17 8 16s722ms 2s90ms 18 8 16s495ms 2s61ms 19 8 16s434ms 2s54ms 20 11 49s270ms 4s479ms 21 9 17s274ms 1s919ms 22 10 17s64ms 1s706ms [ User: intelifix - Total duration: 7m12s - Times executed: 191 ]
[ Application: psql - Total duration: 7m12s - Times executed: 191 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-07 00:05:28 Duration: 26s345ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-07 20:05:17 Duration: 16s284ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-07 20:15:14 Duration: 12s686ms Database: rio User: intelifix Remote: [local] Application: psql
5 2m15s 4 4s376ms 1m3s 33s783ms 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 Sep 07 20 2 1m7s 33s707ms 23 2 1m7s 33s859ms [ User: intelifix - Total duration: 2m15s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m15s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-07 23:16:42 Duration: 1m3s 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-09-07 20:08:40 Duration: 1m3s 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-09-07 23:34:15 Duration: 4s549ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
6 1m46s 4 341ms 52s906ms 26s577ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 07 20 2 53s247ms 26s623ms 23 2 53s62ms 26s531ms [ User: intelifix - Total duration: 1m46s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m46s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-07 20:05:44 Duration: 52s906ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-07 23:13:46 Duration: 52s717ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-07 23:33:40 Duration: 345ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
7 1m45s 6 3s30ms 39s533ms 17s656ms 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 Sep 07 20 3 52s955ms 17s651ms 23 3 52s982ms 17s660ms [ User: intelifix - Total duration: 1m45s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m45s - 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-09-07 23:14:28 Duration: 39s533ms 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-09-07 20:06:26 Duration: 39s370ms 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-09-07 20:10:15 Duration: 10s554ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
8 1m22s 6 2s172ms 31s638ms 13s789ms copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 07 20 3 41s158ms 13s719ms 23 3 41s581ms 13s860ms [ User: intelifix - Total duration: 1m22s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m22s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-09-07 23:15:02 Duration: 31s638ms 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-09-07 20:07:00 Duration: 31s160ms 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-09-07 20:10:24 Duration: 7s807ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
9 1m21s 6 3s84ms 31s607ms 13s663ms 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 #9
Day Hour Count Duration Avg duration Sep 07 20 3 41s6ms 13s668ms 23 3 40s976ms 13s658ms [ User: intelifix - Total duration: 1m21s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m21s - 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-09-07 20:09:11 Duration: 31s607ms 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-09-07 23:17:14 Duration: 31s505ms 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-09-07 23:34:21 Duration: 6s324ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
10 1m20s 1 1m20s 1m20s 1m20s refresh materialized view concurrently rs_mv_codigos_barra;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 07 05 1 1m20s 1m20s [ User: intelifix - Total duration: 1m20s - Times executed: 1 ]
[ Application: psql - Total duration: 1m20s - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-07 05:32:01 Duration: 1m20s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-07 05:31:52 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
11 1m10s 6 2s354ms 23s77ms 11s718ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 07 20 3 34s981ms 11s660ms 23 3 35s330ms 11s776ms [ User: intelifix - Total duration: 1m10s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m10s - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-07 23:10:49 Duration: 23s77ms 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-09-07 20:02:48 Duration: 22s988ms 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-09-07 23:33:09 Duration: 9s898ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
12 1m9s 6 2s204ms 23s906ms 11s650ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 07 20 3 34s742ms 11s580ms 23 3 35s162ms 11s720ms [ User: intelifix - Total duration: 1m9s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m9s - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-07 23:11:30 Duration: 23s906ms 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-09-07 20:03:28 Duration: 23s523ms 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-09-07 23:33:20 Duration: 9s52ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
13 1m7s 6 1s674ms 26s901ms 11s221ms 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 #13
Day Hour Count Duration Avg duration Sep 07 20 3 33s638ms 11s212ms 23 3 33s691ms 11s230ms [ User: intelifix - Total duration: 1m7s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m7s - 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-09-07 20:04:28 Duration: 26s901ms 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-09-07 23:12:30 Duration: 26s721ms 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-09-07 20:10:00 Duration: 5s62ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
14 58s335ms 6 6s808ms 13s195ms 9s722ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 07 00 3 34s319ms 11s439ms 06 3 24s16ms 8s5ms [ User: intelifix - Total duration: 58s335ms - Times executed: 6 ]
[ Application: psql - Total duration: 58s335ms - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-09-07 00:05:15 Duration: 13s195ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-09-07 00:05:36 Duration: 10s982ms Database: contagem User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-09-07 00:05:25 Duration: 10s141ms Database: brasilia User: intelifix Remote: [local] Application: psql
15 54s920ms 4 4s120ms 23s417ms 13s730ms copy public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 07 20 2 27s382ms 13s691ms 23 2 27s537ms 13s768ms [ User: intelifix - Total duration: 54s920ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 54s920ms - Times executed: 4 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-09-07 23:12:53 Duration: 23s417ms 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-09-07 20:04:51 Duration: 23s21ms 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-09-07 20:10:04 Duration: 4s360ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
16 51s371ms 6 1s777ms 16s633ms 8s561ms 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 Sep 07 20 3 25s756ms 8s585ms 23 3 25s615ms 8s538ms [ User: intelifix - Total duration: 51s371ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 51s371ms - 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-09-07 23:11:46 Duration: 16s633ms 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-09-07 20:03:45 Duration: 16s506ms 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-09-07 20:09:52 Duration: 7s456ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
17 49s521ms 59 562ms 1s849ms 839ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 07 08 4 3s643ms 910ms 09 4 2s949ms 737ms 10 4 4s292ms 1s73ms 11 4 2s963ms 740ms 12 3 2s139ms 713ms 13 3 3s332ms 1s110ms 14 4 3s100ms 775ms 15 4 4s201ms 1s50ms 16 3 2s108ms 702ms 17 4 3s215ms 803ms 18 5 3s903ms 780ms 19 4 3s89ms 772ms 20 4 3s273ms 818ms 21 5 4s177ms 835ms 22 4 3s128ms 782ms [ User: intelifix - Total duration: 49s521ms - Times executed: 59 ]
[ Application: psql - Total duration: 49s521ms - Times executed: 59 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-07 15:20:05 Duration: 1s849ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-07 10:20:04 Duration: 1s739ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-07 13:20:03 Duration: 1s705ms Database: brasilia User: intelifix Remote: [local] Application: psql
18 40s413ms 6 1s39ms 16s757ms 6s735ms copy public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 07 20 3 20s96ms 6s698ms 23 3 20s317ms 6s772ms [ User: intelifix - Total duration: 40s413ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 40s413ms - Times executed: 6 ]
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-09-07 23:11:06 Duration: 16s757ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-09-07 20:03:05 Duration: 16s571ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-09-07 23:33:11 Duration: 2s486ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
19 38s72ms 1 38s72ms 38s72ms 38s72ms refresh materialized view concurrently rs_mv_equipamentos;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 07 05 1 38s72ms 38s72ms [ User: intelifix - Total duration: 38s72ms - Times executed: 1 ]
[ Application: psql - Total duration: 38s72ms - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-07 05:30:40 Duration: 38s72ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-07 05:30:36 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
20 33s219ms 31 589ms 6s571ms 1s71ms 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 #20
Day Hour Count Duration Avg duration Sep 07 08 2 7s423ms 3s711ms 09 2 1s470ms 735ms 10 2 1s596ms 798ms 11 2 1s581ms 790ms 12 3 2s217ms 739ms 13 3 2s462ms 820ms 14 2 1s533ms 766ms 15 2 2s628ms 1s314ms 16 3 2s446ms 815ms 17 2 1s570ms 785ms 18 1 869ms 869ms 19 2 1s625ms 812ms 20 2 3s404ms 1s702ms 21 1 718ms 718ms 22 2 1s668ms 834ms [ User: intelifix - Total duration: 33s219ms - Times executed: 31 ]
[ Application: psql - Total duration: 33s219ms - Times executed: 31 ]
-
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-09-07 08:00:08 Duration: 6s571ms 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-09-07 20:20:04 Duration: 2s692ms 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-09-07 15:20:03 Duration: 1s863ms Database: rio User: intelifix Remote: [local] Application: psql
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 191 7m12s 150ms 26s345ms 2s264ms call rs_giga_triagem (?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 07 00 9 45s913ms 5s101ms 01 9 15s737ms 1s748ms 02 8 15s814ms 1s976ms 03 8 13s109ms 1s638ms 04 7 14s812ms 2s116ms 05 8 15s720ms 1s965ms 06 8 15s904ms 1s988ms 07 8 15s614ms 1s951ms 08 7 15s858ms 2s265ms 09 7 15s613ms 2s230ms 10 9 16s43ms 1s782ms 11 7 15s575ms 2s225ms 12 8 17s391ms 2s173ms 13 8 16s533ms 2s66ms 14 8 16s151ms 2s18ms 15 9 16s463ms 1s829ms 16 9 16s962ms 1s884ms 17 8 16s722ms 2s90ms 18 8 16s495ms 2s61ms 19 8 16s434ms 2s54ms 20 11 49s270ms 4s479ms 21 9 17s274ms 1s919ms 22 10 17s64ms 1s706ms [ User: intelifix - Total duration: 7m12s - Times executed: 191 ]
[ Application: psql - Total duration: 7m12s - Times executed: 191 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-07 00:05:28 Duration: 26s345ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-07 20:05:17 Duration: 16s284ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-07 20:15:14 Duration: 12s686ms Database: rio User: intelifix Remote: [local] Application: psql
2 59 49s521ms 562ms 1s849ms 839ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 07 08 4 3s643ms 910ms 09 4 2s949ms 737ms 10 4 4s292ms 1s73ms 11 4 2s963ms 740ms 12 3 2s139ms 713ms 13 3 3s332ms 1s110ms 14 4 3s100ms 775ms 15 4 4s201ms 1s50ms 16 3 2s108ms 702ms 17 4 3s215ms 803ms 18 5 3s903ms 780ms 19 4 3s89ms 772ms 20 4 3s273ms 818ms 21 5 4s177ms 835ms 22 4 3s128ms 782ms [ User: intelifix - Total duration: 49s521ms - Times executed: 59 ]
[ Application: psql - Total duration: 49s521ms - Times executed: 59 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-07 15:20:05 Duration: 1s849ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-07 10:20:04 Duration: 1s739ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-07 13:20:03 Duration: 1s705ms Database: brasilia User: intelifix Remote: [local] Application: psql
3 48 1h33m8s 1s339ms 9m49s 1m56s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 07 07 3 10m35s 3m31s 08 3 5m 1m40s 09 3 5m 1m40s 10 3 4m58s 1m39s 11 3 5m1s 1m40s 12 3 5m15s 1m45s 13 3 5m20s 1m46s 14 3 5m18s 1m46s 15 3 5m12s 1m44s 16 3 5m12s 1m44s 17 3 5m15s 1m45s 18 3 5m13s 1m44s 19 3 5m10s 1m43s 20 3 8m21s 2m47s 21 3 6m55s 2m18s 22 3 5m15s 1m45s [ User: intelifix - Total duration: 1h33m8s - Times executed: 48 ]
[ Application: psql - Total duration: 1h33m8s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-07 07:14:50 Duration: 9m49s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-07 20:12:51 Duration: 7m50s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-07 21:11:40 Duration: 6m39s Database: rio User: intelifix Remote: [local] Application: psql
4 48 1h8m20s 254ms 3m56s 1m25s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 07 07 3 5m54s 1m58s 08 3 3m51s 1m17s 09 3 3m55s 1m18s 10 3 3m51s 1m17s 11 3 3m52s 1m17s 12 3 4m8s 1m22s 13 3 4m8s 1m22s 14 3 4m9s 1m23s 15 3 4m7s 1m22s 16 3 4m8s 1m22s 17 3 4m6s 1m22s 18 3 4m7s 1m22s 19 3 4m4s 1m21s 20 3 5m39s 1m53s 21 3 4m5s 1m21s 22 3 4m8s 1m22s [ User: intelifix - Total duration: 1h8m20s - Times executed: 48 ]
[ Application: psql - Total duration: 1h8m20s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-07 07:21:22 Duration: 3m56s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-07 20:18:53 Duration: 3m50s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-07 14:14:27 Duration: 3m39s Database: brasilia User: intelifix Remote: [local] Application: psql
5 31 33s219ms 589ms 6s571ms 1s71ms 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 #5
Day Hour Count Duration Avg duration Sep 07 08 2 7s423ms 3s711ms 09 2 1s470ms 735ms 10 2 1s596ms 798ms 11 2 1s581ms 790ms 12 3 2s217ms 739ms 13 3 2s462ms 820ms 14 2 1s533ms 766ms 15 2 2s628ms 1s314ms 16 3 2s446ms 815ms 17 2 1s570ms 785ms 18 1 869ms 869ms 19 2 1s625ms 812ms 20 2 3s404ms 1s702ms 21 1 718ms 718ms 22 2 1s668ms 834ms [ User: intelifix - Total duration: 33s219ms - Times executed: 31 ]
[ Application: psql - Total duration: 33s219ms - Times executed: 31 ]
-
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-09-07 08:00:08 Duration: 6s571ms 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-09-07 20:20:04 Duration: 2s692ms 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-09-07 15:20:03 Duration: 1s863ms Database: rio User: intelifix Remote: [local] Application: psql
6 8 7s315ms 182ms 1s968ms 914ms select * from rs_caixa_qr ();Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 07 03 1 182ms 182ms 20 1 1s867ms 1s867ms 23 6 5s265ms 877ms [ User: etiquetas - Total duration: 7s315ms - Times executed: 8 ]
[ Application: [unknown] - Total duration: 7s315ms - Times executed: 8 ]
-
select * from rs_caixa_qr ();
Date: 2026-09-07 23:30:19 Duration: 1s968ms Database: rio User: etiquetas Remote: [local] Application: [unknown] Bind query: yes
-
select * from rs_caixa_qr ();
Date: 2026-09-07 20:29:21 Duration: 1s867ms Database: rio User: etiquetas Remote: [local] Application: [unknown] Bind query: yes
-
select * from rs_caixa_qr ();
Date: 2026-09-07 23:48:44 Duration: 1s607ms Database: rio User: etiquetas Remote: [local] Application: [unknown] Bind query: yes
7 8 3s895ms 170ms 777ms 486ms call rs_giga_tecnicos ();Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 07 00 3 1s712ms 570ms 20 4 1s999ms 499ms 21 1 183ms 183ms [ User: intelifix - Total duration: 3s895ms - Times executed: 8 ]
[ Application: psql - Total duration: 3s895ms - Times executed: 8 ]
-
CALL RS_GIGA_TECNICOS ();
Date: 2026-09-07 00:05:03 Duration: 777ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TECNICOS ();
Date: 2026-09-07 20:05:02 Duration: 733ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TECNICOS ();
Date: 2026-09-07 00:05:02 Duration: 706ms Database: rio User: intelifix Remote: [local] Application: psql
8 8 3s109ms 218ms 540ms 388ms select c.tableoid, c.oid, c.relname, c.relnamespace, c.relkind, c.reltype, c.relowner, c.relchecks, c.relhasindex, c.relhasrules, c.relpages, c.reltuples, c.relallvisible, c.relallfrozen, c.relhastriggers, c.relpersistence, c.reloftype, c.relacl, acldefault( case when c.relkind = ? then ?::"char" else ?::"char" end, c.relowner) as acldefault, case when c.relkind = ? then ( select ftserver from pg_catalog.pg_foreign_table where ftrelid = c.oid) else ? end as foreignserver, c.relfrozenxid, tc.relfrozenxid as tfrozenxid, tc.oid as toid, tc.relpages as toastpages, tc.reloptions as toast_reloptions, d.refobjid as owning_tab, d.refobjsubid as owning_col, tsp.spcname as reltablespace, false as relhasoids, c.relispopulated, c.relreplident, c.relrowsecurity, c.relforcerowsecurity, c.relminmxid, tc.relminmxid as tminmxid, array_remove(array_remove(c.reloptions, ?), ?) as reloptions, case when ? = any (c.reloptions) then ?::text when ? = any (c.reloptions) then ?::text else null end as checkoption, am.amname, (d.deptype = ?) is true as is_identity_sequence, c.relispartition as ispartition from pg_class c left join pg_depend d on (c.relkind = ? and d.classid = ?::regclass and d.objid = c.oid and d.objsubid = ? and d.refclassid = ?::regclass and d.deptype in (...)) left join pg_tablespace tsp on (tsp.oid = c.reltablespace) left join pg_am am on (c.relam = am.oid) left join pg_class tc on (c.reltoastrelid = tc.oid and tc.relkind = ? and c.relkind <> ?) where c.relkind in (...) order by c.oid;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 07 20 3 1s49ms 349ms 23 5 2s59ms 411ms [ User: intelifix - Total duration: 3s109ms - Times executed: 8 ]
[ Application: pg_dump - Total duration: 3s109ms - Times executed: 8 ]
-
SELECT c.tableoid, c.oid, c.relname, c.relnamespace, c.relkind, c.reltype, c.relowner, c.relchecks, c.relhasindex, c.relhasrules, c.relpages, c.reltuples, c.relallvisible, c.relallfrozen, c.relhastriggers, c.relpersistence, c.reloftype, c.relacl, acldefault( CASE WHEN c.relkind = 'S' THEN 's'::"char" ELSE 'r'::"char" END, c.relowner) AS acldefault, CASE WHEN c.relkind = 'f' THEN ( SELECT ftserver FROM pg_catalog.pg_foreign_table WHERE ftrelid = c.oid) ELSE 0 END AS foreignserver, c.relfrozenxid, tc.relfrozenxid AS tfrozenxid, tc.oid AS toid, tc.relpages AS toastpages, tc.reloptions AS toast_reloptions, d.refobjid AS owning_tab, d.refobjsubid AS owning_col, tsp.spcname AS reltablespace, false AS relhasoids, c.relispopulated, c.relreplident, c.relrowsecurity, c.relforcerowsecurity, c.relminmxid, tc.relminmxid AS tminmxid, array_remove(array_remove(c.reloptions, 'check_option=local'), 'check_option=cascaded') AS reloptions, CASE WHEN 'check_option=local' = ANY (c.reloptions) THEN 'LOCAL'::text WHEN 'check_option=cascaded' = ANY (c.reloptions) THEN 'CASCADED'::text ELSE NULL END AS checkoption, am.amname, (d.deptype = 'i') IS TRUE AS is_identity_sequence, c.relispartition AS ispartition FROM pg_class c LEFT JOIN pg_depend d ON (c.relkind = 'S' AND d.classid = 'pg_class'::regclass AND d.objid = c.oid AND d.objsubid = 0 AND d.refclassid = 'pg_class'::regclass AND d.deptype IN ('a', 'i')) LEFT JOIN pg_tablespace tsp ON (tsp.oid = c.reltablespace) LEFT JOIN pg_am am ON (c.relam = am.oid) LEFT JOIN pg_class tc ON (c.reltoastrelid = tc.oid AND tc.relkind = 't' AND c.relkind <> 'p') WHERE c.relkind IN ('r', 'S', 'v', 'c', 'm', 'f', 'p') ORDER BY c.oid;
Date: 2026-09-07 23:42:28 Duration: 540ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
-
SELECT c.tableoid, c.oid, c.relname, c.relnamespace, c.relkind, c.reltype, c.relowner, c.relchecks, c.relhasindex, c.relhasrules, c.relpages, c.reltuples, c.relallvisible, c.relallfrozen, c.relhastriggers, c.relpersistence, c.reloftype, c.relacl, acldefault( CASE WHEN c.relkind = 'S' THEN 's'::"char" ELSE 'r'::"char" END, c.relowner) AS acldefault, CASE WHEN c.relkind = 'f' THEN ( SELECT ftserver FROM pg_catalog.pg_foreign_table WHERE ftrelid = c.oid) ELSE 0 END AS foreignserver, c.relfrozenxid, tc.relfrozenxid AS tfrozenxid, tc.oid AS toid, tc.relpages AS toastpages, tc.reloptions AS toast_reloptions, d.refobjid AS owning_tab, d.refobjsubid AS owning_col, tsp.spcname AS reltablespace, false AS relhasoids, c.relispopulated, c.relreplident, c.relrowsecurity, c.relforcerowsecurity, c.relminmxid, tc.relminmxid AS tminmxid, array_remove(array_remove(c.reloptions, 'check_option=local'), 'check_option=cascaded') AS reloptions, CASE WHEN 'check_option=local' = ANY (c.reloptions) THEN 'LOCAL'::text WHEN 'check_option=cascaded' = ANY (c.reloptions) THEN 'CASCADED'::text ELSE NULL END AS checkoption, am.amname, (d.deptype = 'i') IS TRUE AS is_identity_sequence, c.relispartition AS ispartition FROM pg_class c LEFT JOIN pg_depend d ON (c.relkind = 'S' AND d.classid = 'pg_class'::regclass AND d.objid = c.oid AND d.objsubid = 0 AND d.refclassid = 'pg_class'::regclass AND d.deptype IN ('a', 'i')) LEFT JOIN pg_tablespace tsp ON (tsp.oid = c.reltablespace) LEFT JOIN pg_am am ON (c.relam = am.oid) LEFT JOIN pg_class tc ON (c.reltoastrelid = tc.oid AND tc.relkind = 't' AND c.relkind <> 'p') WHERE c.relkind IN ('r', 'S', 'v', 'c', 'm', 'f', 'p') ORDER BY c.oid;
Date: 2026-09-07 23:17:16 Duration: 486ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
SELECT c.tableoid, c.oid, c.relname, c.relnamespace, c.relkind, c.reltype, c.relowner, c.relchecks, c.relhasindex, c.relhasrules, c.relpages, c.reltuples, c.relallvisible, c.relallfrozen, c.relhastriggers, c.relpersistence, c.reloftype, c.relacl, acldefault( CASE WHEN c.relkind = 'S' THEN 's'::"char" ELSE 'r'::"char" END, c.relowner) AS acldefault, CASE WHEN c.relkind = 'f' THEN ( SELECT ftserver FROM pg_catalog.pg_foreign_table WHERE ftrelid = c.oid) ELSE 0 END AS foreignserver, c.relfrozenxid, tc.relfrozenxid AS tfrozenxid, tc.oid AS toid, tc.relpages AS toastpages, tc.reloptions AS toast_reloptions, d.refobjid AS owning_tab, d.refobjsubid AS owning_col, tsp.spcname AS reltablespace, false AS relhasoids, c.relispopulated, c.relreplident, c.relrowsecurity, c.relforcerowsecurity, c.relminmxid, tc.relminmxid AS tminmxid, array_remove(array_remove(c.reloptions, 'check_option=local'), 'check_option=cascaded') AS reloptions, CASE WHEN 'check_option=local' = ANY (c.reloptions) THEN 'LOCAL'::text WHEN 'check_option=cascaded' = ANY (c.reloptions) THEN 'CASCADED'::text ELSE NULL END AS checkoption, am.amname, (d.deptype = 'i') IS TRUE AS is_identity_sequence, c.relispartition AS ispartition FROM pg_class c LEFT JOIN pg_depend d ON (c.relkind = 'S' AND d.classid = 'pg_class'::regclass AND d.objid = c.oid AND d.objsubid = 0 AND d.refclassid = 'pg_class'::regclass AND d.deptype IN ('a', 'i')) LEFT JOIN pg_tablespace tsp ON (tsp.oid = c.reltablespace) LEFT JOIN pg_am am ON (c.relam = am.oid) LEFT JOIN pg_class tc ON (c.reltoastrelid = tc.oid AND tc.relkind = 't' AND c.relkind <> 'p') WHERE c.relkind IN ('r', 'S', 'v', 'c', 'm', 'f', 'p') ORDER BY c.oid;
Date: 2026-09-07 20:10:48 Duration: 458ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
9 7 3s362ms 291ms 687ms 480ms select p.tableoid, p.oid, p.proname, p.prolang, p.pronargs, p.proargtypes, p.prorettype, p.proacl, acldefault(?, p.proowner) as acldefault, p.pronamespace, p.proowner from pg_proc p left join pg_init_privs pip on (p.oid = pip.objoid and pip.classoid = ?::regclass and pip.objsubid = ?) where p.prokind <> ? and not exists ( select ? from pg_depend where classid = ?::regclass and objid = p.oid and deptype = ?) and (pronamespace != ( select oid from pg_namespace where nspname = ?) or exists ( select ? from pg_cast where pg_cast.oid > ? and p.oid = pg_cast.castfunc) or exists ( select ? from pg_transform where pg_transform.oid > ? and (p.oid = pg_transform.trffromsql or p.oid = pg_transform.trftosql)) or p.proacl is distinct from pip.initprivs);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 07 20 3 1s374ms 458ms 23 4 1s988ms 497ms [ User: intelifix - Total duration: 3s362ms - Times executed: 7 ]
[ Application: pg_dump - Total duration: 3s362ms - Times executed: 7 ]
-
SELECT p.tableoid, p.oid, p.proname, p.prolang, p.pronargs, p.proargtypes, p.prorettype, p.proacl, acldefault('f', p.proowner) AS acldefault, p.pronamespace, p.proowner FROM pg_proc p LEFT JOIN pg_init_privs pip ON (p.oid = pip.objoid AND pip.classoid = 'pg_proc'::regclass AND pip.objsubid = 0) WHERE p.prokind <> 'a' AND NOT EXISTS ( SELECT 1 FROM pg_depend WHERE classid = 'pg_proc'::regclass AND objid = p.oid AND deptype = 'i') AND (pronamespace != ( SELECT oid FROM pg_namespace WHERE nspname = 'pg_catalog') OR EXISTS ( SELECT 1 FROM pg_cast WHERE pg_cast.oid > 16383 AND p.oid = pg_cast.castfunc) OR EXISTS ( SELECT 1 FROM pg_transform WHERE pg_transform.oid > 16383 AND (p.oid = pg_transform.trffromsql OR p.oid = pg_transform.trftosql)) OR p.proacl IS DISTINCT FROM pip.initprivs);
Date: 2026-09-07 23:17:17 Duration: 687ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
SELECT p.tableoid, p.oid, p.proname, p.prolang, p.pronargs, p.proargtypes, p.prorettype, p.proacl, acldefault('f', p.proowner) AS acldefault, p.pronamespace, p.proowner FROM pg_proc p LEFT JOIN pg_init_privs pip ON (p.oid = pip.objoid AND pip.classoid = 'pg_proc'::regclass AND pip.objsubid = 0) WHERE p.prokind <> 'a' AND NOT EXISTS ( SELECT 1 FROM pg_depend WHERE classid = 'pg_proc'::regclass AND objid = p.oid AND deptype = 'i') AND (pronamespace != ( SELECT oid FROM pg_namespace WHERE nspname = 'pg_catalog') OR EXISTS ( SELECT 1 FROM pg_cast WHERE pg_cast.oid > 16383 AND p.oid = pg_cast.castfunc) OR EXISTS ( SELECT 1 FROM pg_transform WHERE pg_transform.oid > 16383 AND (p.oid = pg_transform.trffromsql OR p.oid = pg_transform.trftosql)) OR p.proacl IS DISTINCT FROM pip.initprivs);
Date: 2026-09-07 23:10:03 Duration: 687ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
SELECT p.tableoid, p.oid, p.proname, p.prolang, p.pronargs, p.proargtypes, p.prorettype, p.proacl, acldefault('f', p.proowner) AS acldefault, p.pronamespace, p.proowner FROM pg_proc p LEFT JOIN pg_init_privs pip ON (p.oid = pip.objoid AND pip.classoid = 'pg_proc'::regclass AND pip.objsubid = 0) WHERE p.prokind <> 'a' AND NOT EXISTS ( SELECT 1 FROM pg_depend WHERE classid = 'pg_proc'::regclass AND objid = p.oid AND deptype = 'i') AND (pronamespace != ( SELECT oid FROM pg_namespace WHERE nspname = 'pg_catalog') OR EXISTS ( SELECT 1 FROM pg_cast WHERE pg_cast.oid > 16383 AND p.oid = pg_cast.castfunc) OR EXISTS ( SELECT 1 FROM pg_transform WHERE pg_transform.oid > 16383 AND (p.oid = pg_transform.trffromsql OR p.oid = pg_transform.trftosql)) OR p.proacl IS DISTINCT FROM pip.initprivs);
Date: 2026-09-07 20:02:03 Duration: 622ms Database: rio User: intelifix Remote: [local] Application: pg_dump
10 6 1m45s 3s30ms 39s533ms 17s656ms 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 #10
Day Hour Count Duration Avg duration Sep 07 20 3 52s955ms 17s651ms 23 3 52s982ms 17s660ms [ User: intelifix - Total duration: 1m45s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m45s - 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-09-07 23:14:28 Duration: 39s533ms 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-09-07 20:06:26 Duration: 39s370ms 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-09-07 20:10:15 Duration: 10s554ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
11 6 1m22s 2s172ms 31s638ms 13s789ms 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 Sep 07 20 3 41s158ms 13s719ms 23 3 41s581ms 13s860ms [ User: intelifix - Total duration: 1m22s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m22s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-09-07 23:15:02 Duration: 31s638ms 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-09-07 20:07:00 Duration: 31s160ms 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-09-07 20:10:24 Duration: 7s807ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
12 6 1m21s 3s84ms 31s607ms 13s663ms 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 Sep 07 20 3 41s6ms 13s668ms 23 3 40s976ms 13s658ms [ User: intelifix - Total duration: 1m21s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m21s - 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-09-07 20:09:11 Duration: 31s607ms 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-09-07 23:17:14 Duration: 31s505ms 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-09-07 23:34:21 Duration: 6s324ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
13 6 1m10s 2s354ms 23s77ms 11s718ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 07 20 3 34s981ms 11s660ms 23 3 35s330ms 11s776ms [ User: intelifix - Total duration: 1m10s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m10s - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-07 23:10:49 Duration: 23s77ms 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-09-07 20:02:48 Duration: 22s988ms 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-09-07 23:33:09 Duration: 9s898ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
14 6 1m9s 2s204ms 23s906ms 11s650ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 07 20 3 34s742ms 11s580ms 23 3 35s162ms 11s720ms [ User: intelifix - Total duration: 1m9s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m9s - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-07 23:11:30 Duration: 23s906ms 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-09-07 20:03:28 Duration: 23s523ms 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-09-07 23:33:20 Duration: 9s52ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
15 6 1m7s 1s674ms 26s901ms 11s221ms 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 #15
Day Hour Count Duration Avg duration Sep 07 20 3 33s638ms 11s212ms 23 3 33s691ms 11s230ms [ User: intelifix - Total duration: 1m7s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m7s - 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-09-07 20:04:28 Duration: 26s901ms 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-09-07 23:12:30 Duration: 26s721ms 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-09-07 20:10:00 Duration: 5s62ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
16 6 58s335ms 6s808ms 13s195ms 9s722ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 07 00 3 34s319ms 11s439ms 06 3 24s16ms 8s5ms [ User: intelifix - Total duration: 58s335ms - Times executed: 6 ]
[ Application: psql - Total duration: 58s335ms - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-09-07 00:05:15 Duration: 13s195ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-09-07 00:05:36 Duration: 10s982ms Database: contagem User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-09-07 00:05:25 Duration: 10s141ms Database: brasilia User: intelifix Remote: [local] Application: psql
17 6 51s371ms 1s777ms 16s633ms 8s561ms 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 #17
Day Hour Count Duration Avg duration Sep 07 20 3 25s756ms 8s585ms 23 3 25s615ms 8s538ms [ User: intelifix - Total duration: 51s371ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 51s371ms - 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-09-07 23:11:46 Duration: 16s633ms 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-09-07 20:03:45 Duration: 16s506ms 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-09-07 20:09:52 Duration: 7s456ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
18 6 40s413ms 1s39ms 16s757ms 6s735ms copy public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 07 20 3 20s96ms 6s698ms 23 3 20s317ms 6s772ms [ User: intelifix - Total duration: 40s413ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 40s413ms - Times executed: 6 ]
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-09-07 23:11:06 Duration: 16s757ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-09-07 20:03:05 Duration: 16s571ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-09-07 23:33:11 Duration: 2s486ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
19 6 28s276ms 836ms 12s409ms 4s712ms copy public.fluxo_passos (fp_id, flu_id, wfp_id, res_id, fp_criacao, tec_id, fp_data, mot_id, fp_obs, fp_foto, om_id) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 07 20 3 14s123ms 4s707ms 23 3 14s153ms 4s717ms [ User: intelifix - Total duration: 28s276ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 28s276ms - Times executed: 6 ]
-
COPY public.fluxo_passos (fp_id, flu_id, wfp_id, res_id, fp_criacao, tec_id, fp_data, mot_id, fp_obs, fp_foto, om_id) TO stdout;
Date: 2026-09-07 23:12:03 Duration: 12s409ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxo_passos (fp_id, flu_id, wfp_id, res_id, fp_criacao, tec_id, fp_data, mot_id, fp_obs, fp_foto, om_id) TO stdout;
Date: 2026-09-07 20:04:01 Duration: 12s265ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxo_passos (fp_id, flu_id, wfp_id, res_id, fp_criacao, tec_id, fp_data, mot_id, fp_obs, fp_foto, om_id) TO stdout;
Date: 2026-09-07 20:09:55 Duration: 1s4ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
20 6 27s119ms 2s737ms 5s653ms 4s519ms copy public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 07 20 3 13s462ms 4s487ms 23 3 13s657ms 4s552ms [ User: intelifix - Total duration: 27s119ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 27s119ms - Times executed: 6 ]
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-09-07 23:15:26 Duration: 5s653ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-09-07 20:07:24 Duration: 5s638ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-09-07 23:34:08 Duration: 5s267ms 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 2m51s 10m38s 6m42s 3 20m6s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 07 05 3 20m6s 6m42s [ User: intelifix - Total duration: 20m6s - Times executed: 3 ]
[ Application: psql - Total duration: 20m6s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-09-07 05:10:40 Duration: 10m38s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-07 05:17:16 Duration: 6m36s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-07 05:20:08 Duration: 2m51s Database: contagem User: intelifix Remote: [local] Application: psql
2 1s339ms 9m49s 1m56s 48 1h33m8s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 07 07 3 10m35s 3m31s 08 3 5m 1m40s 09 3 5m 1m40s 10 3 4m58s 1m39s 11 3 5m1s 1m40s 12 3 5m15s 1m45s 13 3 5m20s 1m46s 14 3 5m18s 1m46s 15 3 5m12s 1m44s 16 3 5m12s 1m44s 17 3 5m15s 1m45s 18 3 5m13s 1m44s 19 3 5m10s 1m43s 20 3 8m21s 2m47s 21 3 6m55s 2m18s 22 3 5m15s 1m45s [ User: intelifix - Total duration: 1h33m8s - Times executed: 48 ]
[ Application: psql - Total duration: 1h33m8s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-07 07:14:50 Duration: 9m49s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-07 20:12:51 Duration: 7m50s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-07 21:11:40 Duration: 6m39s Database: rio User: intelifix Remote: [local] Application: psql
3 254ms 3m56s 1m25s 48 1h8m20s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 07 07 3 5m54s 1m58s 08 3 3m51s 1m17s 09 3 3m55s 1m18s 10 3 3m51s 1m17s 11 3 3m52s 1m17s 12 3 4m8s 1m22s 13 3 4m8s 1m22s 14 3 4m9s 1m23s 15 3 4m7s 1m22s 16 3 4m8s 1m22s 17 3 4m6s 1m22s 18 3 4m7s 1m22s 19 3 4m4s 1m21s 20 3 5m39s 1m53s 21 3 4m5s 1m21s 22 3 4m8s 1m22s [ User: intelifix - Total duration: 1h8m20s - Times executed: 48 ]
[ Application: psql - Total duration: 1h8m20s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-07 07:21:22 Duration: 3m56s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-07 20:18:53 Duration: 3m50s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-07 14:14:27 Duration: 3m39s Database: brasilia User: intelifix Remote: [local] Application: psql
4 1m20s 1m20s 1m20s 1 1m20s refresh materialized view concurrently rs_mv_codigos_barra;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 07 05 1 1m20s 1m20s [ User: intelifix - Total duration: 1m20s - Times executed: 1 ]
[ Application: psql - Total duration: 1m20s - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-07 05:32:01 Duration: 1m20s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-07 05:31:52 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
5 38s72ms 38s72ms 38s72ms 1 38s72ms refresh materialized view concurrently rs_mv_equipamentos;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 07 05 1 38s72ms 38s72ms [ User: intelifix - Total duration: 38s72ms - Times executed: 1 ]
[ Application: psql - Total duration: 38s72ms - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-07 05:30:40 Duration: 38s72ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-07 05:30:36 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
6 4s376ms 1m3s 33s783ms 4 2m15s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 07 20 2 1m7s 33s707ms 23 2 1m7s 33s859ms [ User: intelifix - Total duration: 2m15s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m15s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-07 23:16:42 Duration: 1m3s 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-09-07 20:08:40 Duration: 1m3s 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-09-07 23:34:15 Duration: 4s549ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
7 341ms 52s906ms 26s577ms 4 1m46s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 07 20 2 53s247ms 26s623ms 23 2 53s62ms 26s531ms [ User: intelifix - Total duration: 1m46s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m46s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-07 20:05:44 Duration: 52s906ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-07 23:13:46 Duration: 52s717ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-07 23:33:40 Duration: 345ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
8 3s30ms 39s533ms 17s656ms 6 1m45s 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 #8
Day Hour Count Duration Avg duration Sep 07 20 3 52s955ms 17s651ms 23 3 52s982ms 17s660ms [ User: intelifix - Total duration: 1m45s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m45s - 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-09-07 23:14:28 Duration: 39s533ms 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-09-07 20:06:26 Duration: 39s370ms 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-09-07 20:10:15 Duration: 10s554ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
9 2s172ms 31s638ms 13s789ms 6 1m22s 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 Sep 07 20 3 41s158ms 13s719ms 23 3 41s581ms 13s860ms [ User: intelifix - Total duration: 1m22s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m22s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-09-07 23:15:02 Duration: 31s638ms 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-09-07 20:07:00 Duration: 31s160ms 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-09-07 20:10:24 Duration: 7s807ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
10 4s120ms 23s417ms 13s730ms 4 54s920ms copy public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 07 20 2 27s382ms 13s691ms 23 2 27s537ms 13s768ms [ User: intelifix - Total duration: 54s920ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 54s920ms - Times executed: 4 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-09-07 23:12:53 Duration: 23s417ms 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-09-07 20:04:51 Duration: 23s21ms 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-09-07 20:10:04 Duration: 4s360ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
11 3s84ms 31s607ms 13s663ms 6 1m21s 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 #11
Day Hour Count Duration Avg duration Sep 07 20 3 41s6ms 13s668ms 23 3 40s976ms 13s658ms [ User: intelifix - Total duration: 1m21s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m21s - 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-09-07 20:09:11 Duration: 31s607ms 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-09-07 23:17:14 Duration: 31s505ms 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-09-07 23:34:21 Duration: 6s324ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
12 2s354ms 23s77ms 11s718ms 6 1m10s 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 Sep 07 20 3 34s981ms 11s660ms 23 3 35s330ms 11s776ms [ User: intelifix - Total duration: 1m10s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m10s - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-07 23:10:49 Duration: 23s77ms 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-09-07 20:02:48 Duration: 22s988ms 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-09-07 23:33:09 Duration: 9s898ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
13 2s204ms 23s906ms 11s650ms 6 1m9s 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 Sep 07 20 3 34s742ms 11s580ms 23 3 35s162ms 11s720ms [ User: intelifix - Total duration: 1m9s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m9s - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-07 23:11:30 Duration: 23s906ms 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-09-07 20:03:28 Duration: 23s523ms 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-09-07 23:33:20 Duration: 9s52ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
14 1s674ms 26s901ms 11s221ms 6 1m7s 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 Sep 07 20 3 33s638ms 11s212ms 23 3 33s691ms 11s230ms [ User: intelifix - Total duration: 1m7s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m7s - 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-09-07 20:04:28 Duration: 26s901ms 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-09-07 23:12:30 Duration: 26s721ms 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-09-07 20:10:00 Duration: 5s62ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
15 6s808ms 13s195ms 9s722ms 6 58s335ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 07 00 3 34s319ms 11s439ms 06 3 24s16ms 8s5ms [ User: intelifix - Total duration: 58s335ms - Times executed: 6 ]
[ Application: psql - Total duration: 58s335ms - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-09-07 00:05:15 Duration: 13s195ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-09-07 00:05:36 Duration: 10s982ms Database: contagem User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-09-07 00:05:25 Duration: 10s141ms Database: brasilia User: intelifix Remote: [local] Application: psql
16 1s777ms 16s633ms 8s561ms 6 51s371ms 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 Sep 07 20 3 25s756ms 8s585ms 23 3 25s615ms 8s538ms [ User: intelifix - Total duration: 51s371ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 51s371ms - 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-09-07 23:11:46 Duration: 16s633ms 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-09-07 20:03:45 Duration: 16s506ms 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-09-07 20:09:52 Duration: 7s456ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
17 1s39ms 16s757ms 6s735ms 6 40s413ms copy public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 07 20 3 20s96ms 6s698ms 23 3 20s317ms 6s772ms [ User: intelifix - Total duration: 40s413ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 40s413ms - Times executed: 6 ]
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-09-07 23:11:06 Duration: 16s757ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-09-07 20:03:05 Duration: 16s571ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-09-07 23:33:11 Duration: 2s486ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
18 836ms 12s409ms 4s712ms 6 28s276ms copy public.fluxo_passos (fp_id, flu_id, wfp_id, res_id, fp_criacao, tec_id, fp_data, mot_id, fp_obs, fp_foto, om_id) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 07 20 3 14s123ms 4s707ms 23 3 14s153ms 4s717ms [ User: intelifix - Total duration: 28s276ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 28s276ms - Times executed: 6 ]
-
COPY public.fluxo_passos (fp_id, flu_id, wfp_id, res_id, fp_criacao, tec_id, fp_data, mot_id, fp_obs, fp_foto, om_id) TO stdout;
Date: 2026-09-07 23:12:03 Duration: 12s409ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxo_passos (fp_id, flu_id, wfp_id, res_id, fp_criacao, tec_id, fp_data, mot_id, fp_obs, fp_foto, om_id) TO stdout;
Date: 2026-09-07 20:04:01 Duration: 12s265ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxo_passos (fp_id, flu_id, wfp_id, res_id, fp_criacao, tec_id, fp_data, mot_id, fp_obs, fp_foto, om_id) TO stdout;
Date: 2026-09-07 20:09:55 Duration: 1s4ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
19 2s737ms 5s653ms 4s519ms 6 27s119ms copy public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 07 20 3 13s462ms 4s487ms 23 3 13s657ms 4s552ms [ User: intelifix - Total duration: 27s119ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 27s119ms - Times executed: 6 ]
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-09-07 23:15:26 Duration: 5s653ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-09-07 20:07:24 Duration: 5s638ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-09-07 23:34:08 Duration: 5s267ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
20 150ms 26s345ms 2s264ms 191 7m12s call rs_giga_triagem (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 07 00 9 45s913ms 5s101ms 01 9 15s737ms 1s748ms 02 8 15s814ms 1s976ms 03 8 13s109ms 1s638ms 04 7 14s812ms 2s116ms 05 8 15s720ms 1s965ms 06 8 15s904ms 1s988ms 07 8 15s614ms 1s951ms 08 7 15s858ms 2s265ms 09 7 15s613ms 2s230ms 10 9 16s43ms 1s782ms 11 7 15s575ms 2s225ms 12 8 17s391ms 2s173ms 13 8 16s533ms 2s66ms 14 8 16s151ms 2s18ms 15 9 16s463ms 1s829ms 16 9 16s962ms 1s884ms 17 8 16s722ms 2s90ms 18 8 16s495ms 2s61ms 19 8 16s434ms 2s54ms 20 11 49s270ms 4s479ms 21 9 17s274ms 1s919ms 22 10 17s64ms 1s706ms [ User: intelifix - Total duration: 7m12s - Times executed: 191 ]
[ Application: psql - Total duration: 7m12s - Times executed: 191 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-07 00:05:28 Duration: 26s345ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-07 20:05:17 Duration: 16s284ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-07 20:15:14 Duration: 12s686ms Database: rio User: intelifix Remote: [local] Application: psql
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 385ms 2 189ms 196ms 192ms select * from rs_caixa_qr ();Times Reported Time consuming prepare #1
Day Hour Count Duration Avg duration Sep 07 20 1 189ms 189ms 23 1 196ms 196ms [ User: etiquetas - Total duration: 819ms - Times executed: 2 ]
[ Application: [unknown] - Total duration: 819ms - Times executed: 2 ]
-
select * from rs_caixa_qr ();
Date: 2026-09-07 23:48:41 Duration: 196ms Database: postgres User: rio Remote: etiquetas Application: [local] Queryid: [unknown]
-
select * from rs_caixa_qr ();
Date: 2026-09-07 20:29:18 Duration: 189ms Database: postgres User: rio Remote: etiquetas Application: [local] Queryid: [unknown]
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 12 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Sep 07 08 1 0ms 0ms 10 2 0ms 0ms 11 1 0ms 0ms 14 1 0ms 0ms 15 1 0ms 0ms 17 1 0ms 0ms 18 1 0ms 0ms 21 2 0ms 0ms 22 2 0ms 0ms [ User: intelifix - Total duration: 3m46s - Times executed: 12 ]
[ Application: psql - Total duration: 3m46s - Times executed: 12 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 4,825 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 41 FATAL entries
- 1432 ERROR entries
- 0 WARNING entries
- 2 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 1,428 Max number of times the same event was reported
- 1,475 Total events found
Rank Times reported Error 1 1,428 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Sep 07 00 60 01 60 02 59 03 60 04 60 05 59 06 57 07 60 08 60 09 59 10 60 11 60 12 59 13 60 14 60 15 59 16 60 17 59 18 60 19 60 20 59 21 60 22 59 23 59 - ERROR: prepared statement "_PLAN00000000297DC830" does not exist
- ERROR: prepared statement "_PLAN00000000297DBA80" does not exist
- ERROR: prepared statement "_PLAN00000000297E0810" does not exist
Statement: DEALLOCATE "_PLAN00000000297DC830"
Date: 2026-09-07 00:00:06 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN00000000297DBA80"
Date: 2026-09-07 00:01:07 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN00000000297E0810"
Date: 2026-09-07 00:02:07 Database: rio Application: [unknown] User: etiquetas Remote: [local]
2 31 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #2
Day Hour Count Sep 07 00 3 04 3 05 3 06 1 07 1 08 1 09 4 15 1 18 8 21 6 - FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-09-07 00:02:14 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-09-07 00:55:22 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
Date: 2026-09-07 00:55:37 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
3 7 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #3
Day Hour Count Sep 07 03 7 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-09-07 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-09-07 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
Date: 2026-09-07 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local]
4 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #4
Day Hour Count Sep 07 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-09-07 05:32:01 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-07 05:32:01 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-07 05:32:01 Database: contagem Application: psql User: intelifix Remote: [local]
5 2 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #5
Day Hour Count Sep 07 03 2 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-09-07 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Date: 2026-09-07 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
6 1 LOG: could not send data to client: Broken pipe
Times Reported Most Frequent Error / Event #6
Day Hour Count Sep 07 15 1 - LOG: could not send data to client: Broken pipe
Date: 2026-09-07 15:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
7 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #7
Day Hour Count Sep 07 03 1 - LOG: database system was shut down at 2026-09-07 03:05:01 -03
Date: 2026-09-07 03:05:02
8 1 FATAL: connection to client lost
Times Reported Most Frequent Error / Event #8
Day Hour Count Sep 07 15 1 - FATAL: connection to client lost
Date: 2026-09-07 15:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]