pgBadger-
Global information
- Generated on Mon Oct 12 23:50:09 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 4,121 log entries in 8s
- Log start from 2026-10-12 00:02:02 to 2026-10-12 23:44:59
-
Overview
Global Stats
- 144 Number of unique normalized queries
- 918 Number of queries
- 3h55m19s Total query duration
- 2026-10-12 00:02:07 First query
- 2026-10-12 23:44:59 Last query
- 5 queries/s at 2026-10-12 23:42:56 Query peak
- 3h55m19s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 3h55m19s Execute total duration
- 33 Number of events
- 6 Number of unique normalized events
- 18 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
- 250.15 MiB Max size of temporary file
- 68.07 MiB Average size of temporary file
- 162 Total number of sessions
- 7 sessions at 2026-10-12 06:09:34 Session peak
- 6d2h1m35s Total duration of sessions
- 54m5s Average duration of sessions
- 5 Average queries per session
- 1m27s Average queries duration per session
- 52m37s Average idle time per session
- 181 Total number of connections
- 2 connections/s at 2026-10-12 00:05:01 Connection peak
- 4 Total number of databases
SQL Traffic
Key values
- 5 queries/s Query Peak
- 2026-10-12 23:42:56 Date
SELECT Traffic
Key values
- 3 queries/s Query Peak
- 2026-10-12 23:32:33 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 5 queries/s Query Peak
- 2026-10-12 23:42:56 Date
Queries duration
Key values
- 3h55m19s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Oct 12 00 22 0ms 18s705ms 4s10ms 10s525ms 1m2s 1m2s 01 12 0ms 3s12ms 1s536ms 3s105ms 3s263ms 3s263ms 02 12 0ms 3s31ms 1s535ms 3s314ms 3s314ms 3s314ms 03 10 0ms 2s929ms 1s507ms 3s187ms 3s187ms 3s187ms 04 12 0ms 3s35ms 1s539ms 3s272ms 3s272ms 3s272ms 05 17 0ms 9m59s 1m18s 7m8s 9m59s 9m59s 06 19 0ms 11s133ms 2s802ms 9s457ms 28s719ms 28s719ms 07 18 0ms 8m57s 51s779ms 3m56s 8m57s 8m57s 08 24 0ms 5m5s 24s149ms 3m24s 5m48s 5m48s 09 24 184ms 4m59s 23s741ms 3m24s 5m42s 5m42s 10 24 0ms 5m6s 24s1ms 3m22s 5m50s 5m50s 11 24 189ms 5m15s 24s670ms 3m27s 5m44s 5m44s 12 24 0ms 5m2s 23s902ms 3m24s 5m45s 5m45s 13 24 0ms 5m4s 24s147ms 3m29s 5m47s 5m47s 14 24 186ms 5m8s 24s196ms 3m24s 5m52s 5m52s 15 24 186ms 5m5s 24s203ms 3m27s 5m49s 5m49s 16 24 0ms 5m7s 24s666ms 3m37s 5m51s 5m51s 17 24 190ms 5m13s 24s481ms 3m27s 5m57s 5m57s 18 26 0ms 5m5s 22s388ms 3m27s 5m49s 5m49s 19 24 0ms 5m5s 24s121ms 3m26s 5m49s 5m49s 20 114 0ms 7m36s 12s677ms 2m20s 3m49s 7m36s 21 28 0ms 6m17s 23s366ms 3m31s 6m46s 6m46s 22 24 0ms 5m10s 24s810ms 3m36s 5m55s 5m55s 23 340 0ms 1m2s 5s790ms 1m5s 1m6s 1m7s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Oct 12 00 4 0 2s631ms 0ms 0ms 10s525ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 4 0 2s364ms 0ms 0ms 9s457ms 07 6 0 2m32s 1m40s 3m56s 8m57s 08 6 0 1m32s 0ms 3m24s 5m48s 09 6 0 1m31s 0ms 3m24s 5m42s 10 6 0 1m32s 0ms 3m22s 5m50s 11 6 0 1m34s 15s705ms 3m27s 5m44s 12 6 0 1m31s 0ms 3m24s 5m45s 13 6 0 1m32s 0ms 3m29s 5m47s 14 6 0 1m32s 0ms 3m24s 5m52s 15 6 0 1m32s 0ms 3m27s 5m49s 16 6 0 1m34s 0ms 3m37s 5m51s 17 6 0 1m34s 0ms 3m27s 5m57s 18 8 0 1m9s 1s649ms 3m27s 5m49s 19 6 0 1m32s 0ms 3m26s 5m49s 20 15 78 14s914ms 1m8s 2m20s 7m36s 21 8 0 1m18s 15s159ms 3m27s 6m46s 22 6 0 1m35s 0ms 3m36s 5m55s 23 19 321 5s790ms 1m3s 1m5s 1m7s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Oct 12 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Oct 12 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 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 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Day Hour Count Average / Second Oct 12 00 16 0.00/s 01 7 0.00/s 02 6 0.00/s 03 8 0.00/s 04 8 0.00/s 05 7 0.00/s 06 13 0.00/s 07 8 0.00/s 08 6 0.00/s 09 8 0.00/s 10 8 0.00/s 11 8 0.00/s 12 6 0.00/s 13 7 0.00/s 14 5 0.00/s 15 6 0.00/s 16 6 0.00/s 17 5 0.00/s 18 8 0.00/s 19 5 0.00/s 20 9 0.00/s 21 8 0.00/s 22 5 0.00/s 23 8 0.00/s Day Hour Count Average Duration Average idle time Oct 12 00 3 1h 59m30s 01 15 1h1m58s 1h1m57s 02 5 1h1s 59m57s 03 8 25m50s 25m48s 04 5 1h36s 1h32s 05 6 52m10s 48m27s 06 6 58m 57m51s 07 13 1h1m51s 1h39s 08 6 59m59s 58m23s 09 6 1h 58m25s 10 6 51m40s 50m4s 11 6 51m40s 50m1s 12 6 1h50s 59m14s 13 6 51m40s 50m3s 14 5 1h1s 58m5s 15 5 1h1m1s 59m5s 16 7 53m17s 51m52s 17 5 1h 58m3s 18 5 52m 50m3s 19 6 1h51s 59m14s 20 8 39m22s 36m21s 21 6 1h1m33s 59m44s 22 7 1h2m34s 1h1m9s 23 11 30m32s 27m33s -
Connections
Established Connections
Key values
- 2 connections Connection Peak
- 2026-10-12 00:05:01 Date
Connections per database
Key values
- rio Main Database
- 181 connections Total
Connections per user
Key values
- intelifix Main User
- 181 connections Total
-
Sessions
Simultaneous sessions
Key values
- 7 sessions Session Peak
- 2026-10-12 06:09:34 Date
Histogram of session times
Key values
- 137 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 162 sessions Total
Sessions per user
Key values
- intelifix Main User
- 162 sessions Total
Sessions per host
Key values
- [local] Main Host
- 162 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 8,665 buffers Checkpoint Peak
- 2026-10-12 00:09:54 Date
- 269.897 seconds Highest write time
- 0.027 seconds Sync time
Checkpoints Wal files
Key values
- 3 files Wal files usage Peak
- 2026-10-12 00:09:54 Date
Checkpoints distance
Key values
- 94.25 Mo Distance Peak
- 2026-10-12 00:09:54 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Oct 12 00 8,665 269.607s 0.002s 269.613s 01 0 0s 0s 0s 02 0 0s 0s 0s 03 7,234 0.155s 0.028s 0.19s 04 0 0s 0s 0s 05 7,171 718.1s 0.033s 718.151s 06 2,696 269.897s 0.001s 269.911s 07 765 116.638s 0.002s 116.642s 08 32 3.215s 0.001s 3.218s 09 26 2.621s 0.004s 2.629s 10 24 2.413s 0.002s 2.417s 11 23 2.313s 0.002s 2.318s 12 25 2.52s 0.004s 2.528s 13 26 2.622s 0.003s 2.629s 14 25 2.521s 0.003s 2.529s 15 26 2.621s 0.004s 2.629s 16 26 2.621s 0.004s 2.631s 17 24 2.413s 0.001s 2.417s 18 545 54.583s 0.007s 54.6s 19 25 2.521s 0.005s 2.532s 20 53 5.332s 0.005s 5.345s 21 23 2.314s 0.002s 2.318s 22 25 2.521s 0.004s 2.53s 23 23 2.311s 0.002s 2.315s Day Hour Added Removed Recycled Synced files Longest sync Average sync Oct 12 00 0 0 3 32 0.001s 0.001s 01 0 0 0 0 0s 0s 02 0 0 0 0 0s 0s 03 0 0 2 26 0.025s 0.003s 04 0 0 0 0 0s 0s 05 0 0 3 153 0.010s 0.007s 06 0 0 1 10 0.001s 0.001s 07 0 0 0 13 0.001s 0.001s 08 0 0 0 3 0.001s 0.001s 09 0 0 0 5 0.001s 0.002s 10 0 0 0 3 0.002s 0.001s 11 0 0 0 3 0.001s 0.001s 12 0 0 0 5 0.001s 0.002s 13 0 0 0 5 0.001s 0.002s 14 0 0 0 5 0.001s 0.002s 15 0 0 0 5 0.002s 0.002s 16 0 0 0 5 0.002s 0.002s 17 0 0 0 3 0.001s 0.001s 18 0 0 1 33 0.002s 0.004s 19 0 0 0 5 0.002s 0.002s 20 0 0 0 17 0.002s 0.003s 21 0 0 0 3 0.001s 0.001s 22 0 0 0 5 0.001s 0.002s 23 0 0 0 1 0.002s 0.002s Day Hour Count Avg time (sec) Oct 12 00 0 0s 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s 23 0 0s Day Hour Mean distance Mean estimate Oct 12 00 48,256.00 kB 48,256.00 kB 01 0.00 kB 0.00 kB 02 0.00 kB 0.00 kB 03 22,714.00 kB 23,986.50 kB 04 0.00 kB 0.00 kB 05 7,245.43 kB 10,224.00 kB 06 7,226.00 kB 11,105.00 kB 07 7,374.00 kB 10,732.00 kB 08 271.00 kB 9,686.00 kB 09 96.00 kB 8,292.50 kB 10 190.00 kB 7,097.00 kB 11 189.00 kB 6,406.00 kB 12 96.50 kB 5,489.00 kB 13 96.00 kB 4,463.50 kB 14 96.00 kB 3,633.00 kB 15 96.00 kB 2,962.00 kB 16 96.00 kB 2,416.50 kB 17 190.00 kB 2,087.00 kB 18 484.00 kB 1,768.50 kB 19 96.00 kB 1,309.00 kB 20 276.33 kB 1,056.33 kB 21 189.00 kB 907.00 kB 22 96.50 kB 787.00 kB 23 77.00 kB 686.00 kB -
Temporary Files
Size of temporary files
Key values
- 500.30 MiB Temp Files size Peak
- 2026-10-12 05:31:55 Date
Number of temporary files
Key values
- 4 per second Temp Files Peak
- 2026-10-12 05:32:03 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Oct 12 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 20 1.33 GiB 68.07 MiB 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 16 1.03 GiB 37.31 MiB 250.15 MiB 65.66 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-10-12 05:32:04 Duration: 1m23s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-10-12 05:31:55 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 4 310.75 MiB 57.75 MiB 95.05 MiB 77.69 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-10-12 05:30:41 Duration: 39s595ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-10-12 05:30:37 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
Queries generating the largest temporary files
Rank Size Query 1 250.15 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-12 05:31:55 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 250.15 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-12 05:31:55 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 95.05 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-10-12 05:30:37 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 95.05 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-10-12 05:30:37 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 62.91 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-10-12 05:30:40 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 57.75 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-10-12 05:30:41 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 41.35 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-12 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 41.29 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-12 05:32:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 41.29 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-12 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 41.28 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-12 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 41.28 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-12 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 41.28 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-12 05:32:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 41.28 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-12 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 37.37 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-12 05:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 37.31 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-12 05:32:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 37.31 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-12 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 37.31 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-12 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 37.31 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-12 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 37.31 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-12 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 37.31 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-12 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0.28 sec Highest CPU-cost vacuum
Table pg_catalog.pg_statistic
Database rio - 2026-10-12 05:10:33 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 0.28 sec Highest CPU-cost vacuum
Table pg_catalog.pg_statistic
Database rio - 2026-10-12 05:10:33 Date
Analyzes per table
Key values
- unknown (0) Main table analyzed (database )
- 0 analyzes Total
Vacuums per table
Key values
- pg_toast.pg_toast_2619 (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_toast.pg_toast_2619 1 1 0 0 0 0 0 211 38 203,302 29 76 contagem.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,282 1,036 3,184,942 1,006 7,274 rio.pg_catalog.pg_statistic 1 1 0 0 0 0 0 3,208 1,304 4,406,411 1,250 7,432 brasilia.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,833 590 2,515,890 554 3,804 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 128 54 172,876 24 54 rio.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 743 263 1,232,599 172 396 Total 6 6 0 0 0 0 0 9,405 3,285 11,716,020 3,035 19,036 Vacuum throughput per table
Key values
- pg_catalog.pg_statistic (0.28) 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 (4725) Main table with removed tuples on database rio
- 13559 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_statistic 1 1 4,725 7,464 0 0 1,286 contagem.pg_catalog.pg_statistic 1 1 4,178 7,274 0 0 1,011 brasilia.pg_catalog.pg_statistic 1 1 3,850 7,360 0 0 1,071 rio.pg_toast.pg_toast_2619 1 1 592 677 0 0 257 brasilia.pg_toast.pg_toast_2619 1 1 112 140 0 0 64 contagem.pg_toast.pg_toast_2619 1 1 102 114 0 0 51 Total 6 6 13,559 23,029 0 0 3,740 Pages removed per table
Key values
- unknown (0) Main table with removed pages on database unknown
- 0 pages Total removed
Pages removed per tables
NO DATASET
Table Number of vacuums Index scans Tuples removed Pages removed brasilia.pg_toast.pg_toast_2619 1 1 112 0 contagem.pg_catalog.pg_statistic 1 1 4178 0 rio.pg_catalog.pg_statistic 1 1 4725 0 brasilia.pg_catalog.pg_statistic 1 1 3850 0 contagem.pg_toast.pg_toast_2619 1 1 102 0 rio.pg_toast.pg_toast_2619 1 1 592 0 Total 6 6 13,559 0 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Oct 12 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.28 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
- 136 Total read queries
- 399 Total write queries
Queries by database
Key values
- rio Main database
- 384 Requests
- 2h29m52s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 910 Requests
User Request type Count Duration intelifix Total 910 3h54m59s copy to 399 42m others 383 32m17s select 128 2h40m41s lenon Total 8 19s983ms select 8 19s983ms Duration by user
Key values
- 3h54m59s (intelifix) Main time consuming user
User Request type Count Duration intelifix Total 910 3h54m59s copy to 399 42m others 383 32m17s select 128 2h40m41s lenon Total 8 19s983ms select 8 19s983ms Queries by host
Key values
- [local] Main host
- 918 Requests
- 3h55m19s ([local])
- Main time consuming host
Queries by application
Key values
- psql Main application
- 490 Requests
- 3h13m10s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-10-12 18:10:43 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 334 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 9m59s analyze verbose;[ Date: 2026-10-12 05:10:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 8m57s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-12 07:13:59 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 7m36s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-12 20:12:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 7m8s analyze verbose;[ Date: 2026-10-12 05:17:09 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
5 6m17s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-12 21:11:19 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 5m15s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-12 11:10:17 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 5m13s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-12 17:10:14 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 5m10s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-12 22:10:12 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 5m8s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-12 14:10:09 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 5m7s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-12 16:10:09 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 5m6s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-12 10:10:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 5m5s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-12 18:10:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 5m5s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-12 15:10:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 5m5s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-12 19:10:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 5m5s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-12 08:10:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 5m4s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-12 13:10:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 5m2s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-12 12:10:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 4m59s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-12 09:10:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 3m46s SELECT * FROM RS_SMART_FISCAL_SAIDA ();[ Date: 2026-10-12 07:20:05 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
20 3m39s SELECT * FROM RS_SMART_FISCAL_SAIDA ();[ Date: 2026-10-12 20:18:38 - 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 1h34m50s 48 2s137ms 8m57s 1m58s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 12 07 3 9m44s 3m14s 08 3 5m22s 1m47s 09 3 5m16s 1m45s 10 3 5m23s 1m47s 11 3 5m33s 1m51s 12 3 5m19s 1m46s 13 3 5m21s 1m47s 14 3 5m26s 1m48s 15 3 5m23s 1m47s 16 3 5m25s 1m48s 17 3 5m31s 1m50s 18 3 5m22s 1m47s 19 3 5m22s 1m47s 20 3 8m14s 2m44s 21 3 6m35s 2m11s 22 3 5m28s 1m49s [ User: intelifix - Total duration: 1h34m50s - Times executed: 48 ]
[ Application: psql - Total duration: 1h34m50s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-12 07:13:59 Duration: 8m57s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-12 20:12:38 Duration: 7m36s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-12 21:11:19 Duration: 6m17s Database: rio User: intelifix Remote: [local] Application: psql
2 1h5m37s 47 229ms 3m46s 1m23s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 12 07 3 5m29s 1m49s 08 3 3m51s 1m17s 09 3 3m50s 1m16s 10 3 3m49s 1m16s 11 3 3m54s 1m18s 12 3 3m50s 1m16s 13 3 3m55s 1m18s 14 3 3m50s 1m16s 15 3 3m54s 1m18s 16 3 4m3s 1m21s 17 3 3m53s 1m17s 18 3 3m53s 1m17s 19 3 3m53s 1m17s 20 2 5m30s 2m45s 21 3 3m54s 1m18s 22 3 4m3s 1m21s [ User: intelifix - Total duration: 1h5m37s - Times executed: 47 ]
[ Application: psql - Total duration: 1h5m37s - Times executed: 47 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-12 07:20:05 Duration: 3m46s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-12 20:18:38 Duration: 3m39s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-12 16:14:28 Duration: 3m34s Database: brasilia User: intelifix Remote: [local] Application: psql
3 19m58s 3 2m49s 9m59s 6m39s analyze verbose;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 12 05 3 19m58s 6m39s [ User: intelifix - Total duration: 19m58s - Times executed: 3 ]
[ Application: psql - Total duration: 19m58s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-10-12 05:10:00 Duration: 9m59s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-10-12 05:17:09 Duration: 7m8s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-10-12 05:19:59 Duration: 2m49s Database: contagem User: intelifix Remote: [local] Application: psql
4 7m49s 254 175ms 18s705ms 1s846ms call rs_giga_triagem (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 12 00 12 38s91ms 3s174ms 01 12 18s441ms 1s536ms 02 12 18s424ms 1s535ms 03 10 15s79ms 1s507ms 04 12 18s475ms 1s539ms 05 12 18s92ms 1s507ms 06 12 18s152ms 1s512ms 07 11 17s972ms 1s633ms 08 10 17s801ms 1s780ms 09 10 17s836ms 1s783ms 10 11 17s746ms 1s613ms 11 11 18s453ms 1s677ms 12 12 18s699ms 1s558ms 13 11 17s943ms 1s631ms 14 10 18s334ms 1s833ms 15 11 18s658ms 1s696ms 16 10 17s844ms 1s784ms 17 10 18s243ms 1s824ms 18 11 18s546ms 1s686ms 19 11 18s142ms 1s649ms 20 10 50s537ms 5s53ms 21 11 18s341ms 1s667ms 22 12 19s247ms 1s603ms [ User: intelifix - Total duration: 7m49s - Times executed: 254 ]
[ Application: psql - Total duration: 7m49s - Times executed: 254 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-12 00:05:20 Duration: 18s705ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-12 20:05:18 Duration: 16s865ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-12 20:15:14 Duration: 13s386ms Database: rio User: intelifix Remote: [local] Application: psql
5 2m16s 4 4s329ms 1m4s 34s12ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 12 20 2 1m8s 34s400ms 23 2 1m7s 33s624ms [ User: intelifix - Total duration: 2m16s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m16s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-10-12 20:08:47 Duration: 1m4s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-10-12 23:16:42 Duration: 1m2s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-10-12 20:10:47 Duration: 4s484ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
6 1m49s 6 3s332ms 40s786ms 18s296ms 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 #6
Day Hour Count Duration Avg duration Oct 12 20 3 54s851ms 18s283ms 23 3 54s927ms 18s309ms [ User: intelifix - Total duration: 1m49s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m49s - Times executed: 6 ]
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-10-12 20:06:30 Duration: 40s786ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-10-12 23:14:28 Duration: 40s591ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-10-12 20:10:23 Duration: 10s731ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
7 1m48s 4 343ms 54s30ms 27s51ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Oct 12 20 2 54s382ms 27s191ms 23 2 53s824ms 26s912ms [ User: intelifix - Total duration: 1m48s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m48s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-10-12 20:05:47 Duration: 54s30ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-10-12 23:13:45 Duration: 53s481ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-10-12 20:10:12 Duration: 351ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
8 1m24s 6 2s327ms 32s841ms 14s146ms 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 Oct 12 20 3 42s959ms 14s319ms 23 3 41s917ms 13s972ms [ User: intelifix - Total duration: 1m24s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m24s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-10-12 20:07:06 Duration: 32s841ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-10-12 23:15:03 Duration: 31s720ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-10-12 23:33:43 Duration: 7s868ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
9 1m23s 6 3s1ms 32s130ms 13s940ms 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 Oct 12 20 3 42s5ms 14s1ms 23 3 41s635ms 13s878ms [ User: intelifix - Total duration: 1m23s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m23s - Times executed: 6 ]
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-10-12 20:09:19 Duration: 32s130ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-10-12 23:17:14 Duration: 32s60ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-10-12 20:10:54 Duration: 6s655ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
10 1m23s 1 1m23s 1m23s 1m23s refresh materialized view concurrently rs_mv_codigos_barra;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Oct 12 05 1 1m23s 1m23s [ User: intelifix - Total duration: 1m23s - Times executed: 1 ]
[ Application: psql - Total duration: 1m23s - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-10-12 05:32:04 Duration: 1m23s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-10-12 05:31:55 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
11 1m12s 6 2s516ms 24s70ms 12s75ms 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 Oct 12 20 3 36s442ms 12s147ms 23 3 36s7ms 12s2ms [ User: intelifix - Total duration: 1m12s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m12s - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-10-12 20:02:48 Duration: 24s70ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-10-12 23:10:48 Duration: 23s665ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-10-12 23:32:52 Duration: 9s825ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
12 1m11s 6 2s257ms 24s357ms 11s978ms 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 Oct 12 20 3 36s32ms 12s10ms 23 3 35s836ms 11s945ms [ User: intelifix - Total duration: 1m11s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m11s - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-10-12 20:03:30 Duration: 24s357ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-10-12 23:11:29 Duration: 24s304ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-10-12 23:33:04 Duration: 9s274ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
13 1m5s 6 1s759ms 25s917ms 10s867ms 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 Oct 12 20 3 32s740ms 10s913ms 23 3 32s466ms 10s822ms [ User: intelifix - Total duration: 1m5s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m5s - Times executed: 6 ]
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-10-12 20:04:30 Duration: 25s917ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-10-12 23:12:28 Duration: 25s387ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-10-12 23:33:19 Duration: 5s277ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
14 1m3s 6 5s756ms 14s827ms 10s595ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Oct 12 00 3 37s929ms 12s643ms 06 3 25s643ms 8s547ms [ User: intelifix - Total duration: 1m3s - Times executed: 6 ]
[ Application: psql - Total duration: 1m3s - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-10-12 00:05:29 Duration: 14s827ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-10-12 00:05:14 Duration: 13s98ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-10-12 06:05:21 Duration: 11s133ms Database: brasilia User: intelifix Remote: [local] Application: psql
15 56s83ms 4 4s302ms 23s742ms 14s20ms 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 Oct 12 20 2 28s104ms 14s52ms 23 2 27s979ms 13s989ms [ User: intelifix - Total duration: 56s83ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 56s83ms - Times executed: 4 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-10-12 20:04:53 Duration: 23s742ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-10-12 23:12:52 Duration: 23s676ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-10-12 20:10:12 Duration: 4s362ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
16 51s712ms 6 1s835ms 16s854ms 8s618ms copy public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 12 20 3 26s20ms 8s673ms 23 3 25s692ms 8s564ms [ User: intelifix - Total duration: 51s712ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 51s712ms - Times executed: 6 ]
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-10-12 20:03:47 Duration: 16s854ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-10-12 23:11:46 Duration: 16s661ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-10-12 20:09:59 Duration: 7s221ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
17 43s613ms 56 561ms 995ms 778ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Oct 12 08 4 3s283ms 820ms 09 4 3s68ms 767ms 10 4 3s450ms 862ms 11 4 3s224ms 806ms 12 4 3s54ms 763ms 13 5 3s795ms 759ms 14 3 2s519ms 839ms 15 4 3s59ms 764ms 16 4 3s212ms 803ms 17 3 2s159ms 719ms 18 4 3s235ms 808ms 19 3 2s238ms 746ms 20 4 3s162ms 790ms 21 3 2s16ms 672ms 22 3 2s134ms 711ms [ User: intelifix - Total duration: 43s613ms - Times executed: 56 ]
[ Application: psql - Total duration: 43s613ms - Times executed: 56 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-12 08:00:06 Duration: 995ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-12 10:00:03 Duration: 974ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-12 13:00:02 Duration: 957ms Database: rio User: intelifix Remote: [local] Application: psql
18 41s694ms 6 1s30ms 17s360ms 6s949ms 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 Oct 12 20 3 21s48ms 7s16ms 23 3 20s646ms 6s882ms [ User: intelifix - Total duration: 41s694ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 41s694ms - 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-10-12 20:03:05 Duration: 17s360ms 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-10-12 23:11:05 Duration: 16s828ms 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-10-12 23:32:55 Duration: 2s753ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
19 39s595ms 1 39s595ms 39s595ms 39s595ms refresh materialized view concurrently rs_mv_equipamentos;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 12 05 1 39s595ms 39s595ms [ User: intelifix - Total duration: 39s595ms - Times executed: 1 ]
[ Application: psql - Total duration: 39s595ms - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-10-12 05:30:41 Duration: 39s595ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-10-12 05:30:37 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
20 32s474ms 34 698ms 3s545ms 955ms 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 Oct 12 08 2 4s479ms 2s239ms 09 2 1s619ms 809ms 10 2 1s443ms 721ms 11 2 2s45ms 1s22ms 12 2 1s828ms 914ms 13 1 735ms 735ms 14 3 2s558ms 852ms 15 2 1s758ms 879ms 16 2 1s539ms 769ms 17 3 2s570ms 856ms 18 2 1s916ms 958ms 19 3 2s435ms 811ms 20 2 2s686ms 1s343ms 21 3 2s440ms 813ms 22 3 2s416ms 805ms [ User: intelifix - Total duration: 32s474ms - Times executed: 34 ]
[ Application: psql - Total duration: 32s474ms - Times executed: 34 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-10-12 08:00:05 Duration: 3s545ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-10-12 20:20:03 Duration: 1s830ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-10-12 11:20:02 Duration: 1s43ms 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 254 7m49s 175ms 18s705ms 1s846ms call rs_giga_triagem (?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 12 00 12 38s91ms 3s174ms 01 12 18s441ms 1s536ms 02 12 18s424ms 1s535ms 03 10 15s79ms 1s507ms 04 12 18s475ms 1s539ms 05 12 18s92ms 1s507ms 06 12 18s152ms 1s512ms 07 11 17s972ms 1s633ms 08 10 17s801ms 1s780ms 09 10 17s836ms 1s783ms 10 11 17s746ms 1s613ms 11 11 18s453ms 1s677ms 12 12 18s699ms 1s558ms 13 11 17s943ms 1s631ms 14 10 18s334ms 1s833ms 15 11 18s658ms 1s696ms 16 10 17s844ms 1s784ms 17 10 18s243ms 1s824ms 18 11 18s546ms 1s686ms 19 11 18s142ms 1s649ms 20 10 50s537ms 5s53ms 21 11 18s341ms 1s667ms 22 12 19s247ms 1s603ms [ User: intelifix - Total duration: 7m49s - Times executed: 254 ]
[ Application: psql - Total duration: 7m49s - Times executed: 254 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-12 00:05:20 Duration: 18s705ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-12 20:05:18 Duration: 16s865ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-12 20:15:14 Duration: 13s386ms Database: rio User: intelifix Remote: [local] Application: psql
2 56 43s613ms 561ms 995ms 778ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 12 08 4 3s283ms 820ms 09 4 3s68ms 767ms 10 4 3s450ms 862ms 11 4 3s224ms 806ms 12 4 3s54ms 763ms 13 5 3s795ms 759ms 14 3 2s519ms 839ms 15 4 3s59ms 764ms 16 4 3s212ms 803ms 17 3 2s159ms 719ms 18 4 3s235ms 808ms 19 3 2s238ms 746ms 20 4 3s162ms 790ms 21 3 2s16ms 672ms 22 3 2s134ms 711ms [ User: intelifix - Total duration: 43s613ms - Times executed: 56 ]
[ Application: psql - Total duration: 43s613ms - Times executed: 56 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-12 08:00:06 Duration: 995ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-12 10:00:03 Duration: 974ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-12 13:00:02 Duration: 957ms Database: rio User: intelifix Remote: [local] Application: psql
3 48 1h34m50s 2s137ms 8m57s 1m58s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 12 07 3 9m44s 3m14s 08 3 5m22s 1m47s 09 3 5m16s 1m45s 10 3 5m23s 1m47s 11 3 5m33s 1m51s 12 3 5m19s 1m46s 13 3 5m21s 1m47s 14 3 5m26s 1m48s 15 3 5m23s 1m47s 16 3 5m25s 1m48s 17 3 5m31s 1m50s 18 3 5m22s 1m47s 19 3 5m22s 1m47s 20 3 8m14s 2m44s 21 3 6m35s 2m11s 22 3 5m28s 1m49s [ User: intelifix - Total duration: 1h34m50s - Times executed: 48 ]
[ Application: psql - Total duration: 1h34m50s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-12 07:13:59 Duration: 8m57s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-12 20:12:38 Duration: 7m36s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-12 21:11:19 Duration: 6m17s Database: rio User: intelifix Remote: [local] Application: psql
4 47 1h5m37s 229ms 3m46s 1m23s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 12 07 3 5m29s 1m49s 08 3 3m51s 1m17s 09 3 3m50s 1m16s 10 3 3m49s 1m16s 11 3 3m54s 1m18s 12 3 3m50s 1m16s 13 3 3m55s 1m18s 14 3 3m50s 1m16s 15 3 3m54s 1m18s 16 3 4m3s 1m21s 17 3 3m53s 1m17s 18 3 3m53s 1m17s 19 3 3m53s 1m17s 20 2 5m30s 2m45s 21 3 3m54s 1m18s 22 3 4m3s 1m21s [ User: intelifix - Total duration: 1h5m37s - Times executed: 47 ]
[ Application: psql - Total duration: 1h5m37s - Times executed: 47 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-12 07:20:05 Duration: 3m46s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-12 20:18:38 Duration: 3m39s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-12 16:14:28 Duration: 3m34s Database: brasilia User: intelifix Remote: [local] Application: psql
5 34 32s474ms 698ms 3s545ms 955ms 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 Oct 12 08 2 4s479ms 2s239ms 09 2 1s619ms 809ms 10 2 1s443ms 721ms 11 2 2s45ms 1s22ms 12 2 1s828ms 914ms 13 1 735ms 735ms 14 3 2s558ms 852ms 15 2 1s758ms 879ms 16 2 1s539ms 769ms 17 3 2s570ms 856ms 18 2 1s916ms 958ms 19 3 2s435ms 811ms 20 2 2s686ms 1s343ms 21 3 2s440ms 813ms 22 3 2s416ms 805ms [ User: intelifix - Total duration: 32s474ms - Times executed: 34 ]
[ Application: psql - Total duration: 32s474ms - Times executed: 34 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-10-12 08:00:05 Duration: 3s545ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-10-12 20:20:03 Duration: 1s830ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-10-12 11:20:02 Duration: 1s43ms Database: rio User: intelifix Remote: [local] Application: psql
6 18 3s617ms 177ms 274ms 200ms call rs_giga_triagem (?) / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 12 07 1 274ms 274ms 08 1 191ms 191ms 09 1 192ms 192ms 10 1 188ms 188ms 11 1 189ms 189ms 13 1 184ms 184ms 14 2 428ms 214ms 15 1 187ms 187ms 16 2 373ms 186ms 17 2 433ms 216ms 18 1 194ms 194ms 19 1 187ms 187ms 20 2 382ms 191ms 21 1 208ms 208ms [ User: intelifix - Total duration: 3s617ms - Times executed: 18 ]
[ Application: psql - Total duration: 3s617ms - Times executed: 18 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR') / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-10-12 07:55:04 Duration: 274ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR') / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-10-12 17:55:04 Duration: 242ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR') / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-10-12 14:35:04 Duration: 240ms Database: brasilia User: intelifix Remote: [local] Application: psql
7 8 19s983ms 305ms 5s159ms 2s497ms select * from rs_auditor_novas_tabelas ();Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Oct 12 00 4 10s525ms 2s631ms 06 4 9s457ms 2s364ms [ User: lenon - Total duration: 19s983ms - Times executed: 8 ]
[ Application: psql - Total duration: 19s983ms - Times executed: 8 ]
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-10-12 00:02:07 Duration: 5s159ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-10-12 06:02:06 Duration: 5s56ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-10-12 00:02:11 Duration: 3s794ms Database: brasilia User: lenon Remote: [local] Application: psql
8 7 2s352ms 235ms 522ms 336ms 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 #8
Day Hour Count Duration Avg duration Oct 12 20 3 804ms 268ms 23 4 1s547ms 386ms [ User: intelifix - Total duration: 2s352ms - Times executed: 7 ]
[ Application: pg_dump - Total duration: 2s352ms - 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-10-12 23:10:02 Duration: 522ms 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-10-12 23:42:03 Duration: 387ms Database: contagem 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-10-12 23:17:16 Duration: 334ms Database: rio User: intelifix Remote: [local] Application: pg_dump
9 7 2s229ms 198ms 460ms 318ms 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 #9
Day Hour Count Duration Avg duration Oct 12 20 3 741ms 247ms 23 4 1s488ms 372ms [ User: intelifix - Total duration: 2s229ms - Times executed: 7 ]
[ Application: pg_dump - Total duration: 2s229ms - Times executed: 7 ]
-
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-10-12 23:10:02 Duration: 460ms 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-10-12 23:17:16 Duration: 408ms 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-10-12 23:32:32 Duration: 333ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
10 6 1m49s 3s332ms 40s786ms 18s296ms 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 Oct 12 20 3 54s851ms 18s283ms 23 3 54s927ms 18s309ms [ User: intelifix - Total duration: 1m49s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m49s - Times executed: 6 ]
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-10-12 20:06:30 Duration: 40s786ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-10-12 23:14:28 Duration: 40s591ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-10-12 20:10:23 Duration: 10s731ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
11 6 1m24s 2s327ms 32s841ms 14s146ms copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 12 20 3 42s959ms 14s319ms 23 3 41s917ms 13s972ms [ User: intelifix - Total duration: 1m24s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m24s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-10-12 20:07:06 Duration: 32s841ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-10-12 23:15:03 Duration: 31s720ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-10-12 23:33:43 Duration: 7s868ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
12 6 1m23s 3s1ms 32s130ms 13s940ms copy public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 12 20 3 42s5ms 14s1ms 23 3 41s635ms 13s878ms [ User: intelifix - Total duration: 1m23s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m23s - Times executed: 6 ]
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-10-12 20:09:19 Duration: 32s130ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-10-12 23:17:14 Duration: 32s60ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-10-12 20:10:54 Duration: 6s655ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
13 6 1m12s 2s516ms 24s70ms 12s75ms 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 Oct 12 20 3 36s442ms 12s147ms 23 3 36s7ms 12s2ms [ User: intelifix - Total duration: 1m12s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m12s - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-10-12 20:02:48 Duration: 24s70ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-10-12 23:10:48 Duration: 23s665ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-10-12 23:32:52 Duration: 9s825ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
14 6 1m11s 2s257ms 24s357ms 11s978ms 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 Oct 12 20 3 36s32ms 12s10ms 23 3 35s836ms 11s945ms [ User: intelifix - Total duration: 1m11s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m11s - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-10-12 20:03:30 Duration: 24s357ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-10-12 23:11:29 Duration: 24s304ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-10-12 23:33:04 Duration: 9s274ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
15 6 1m5s 1s759ms 25s917ms 10s867ms 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 Oct 12 20 3 32s740ms 10s913ms 23 3 32s466ms 10s822ms [ User: intelifix - Total duration: 1m5s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m5s - Times executed: 6 ]
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-10-12 20:04:30 Duration: 25s917ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-10-12 23:12:28 Duration: 25s387ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-10-12 23:33:19 Duration: 5s277ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
16 6 1m3s 5s756ms 14s827ms 10s595ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 12 00 3 37s929ms 12s643ms 06 3 25s643ms 8s547ms [ User: intelifix - Total duration: 1m3s - Times executed: 6 ]
[ Application: psql - Total duration: 1m3s - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-10-12 00:05:29 Duration: 14s827ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-10-12 00:05:14 Duration: 13s98ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-10-12 06:05:21 Duration: 11s133ms Database: brasilia User: intelifix Remote: [local] Application: psql
17 6 51s712ms 1s835ms 16s854ms 8s618ms 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 Oct 12 20 3 26s20ms 8s673ms 23 3 25s692ms 8s564ms [ User: intelifix - Total duration: 51s712ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 51s712ms - Times executed: 6 ]
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-10-12 20:03:47 Duration: 16s854ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-10-12 23:11:46 Duration: 16s661ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-10-12 20:09:59 Duration: 7s221ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
18 6 41s694ms 1s30ms 17s360ms 6s949ms 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 Oct 12 20 3 21s48ms 7s16ms 23 3 20s646ms 6s882ms [ User: intelifix - Total duration: 41s694ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 41s694ms - 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-10-12 20:03:05 Duration: 17s360ms 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-10-12 23:11:05 Duration: 16s828ms 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-10-12 23:32:55 Duration: 2s753ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
19 6 29s355ms 902ms 12s730ms 4s892ms 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 Oct 12 20 3 14s777ms 4s925ms 23 3 14s577ms 4s859ms [ User: intelifix - Total duration: 29s355ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 29s355ms - 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-10-12 20:04:04 Duration: 12s730ms 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-10-12 23:12:03 Duration: 12s674ms 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-10-12 20:10:02 Duration: 1s119ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
20 6 27s728ms 2s941ms 5s753ms 4s621ms 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 Oct 12 20 3 13s937ms 4s645ms 23 3 13s791ms 4s597ms [ User: intelifix - Total duration: 27s728ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 27s728ms - 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-10-12 20:07:30 Duration: 5s753ms 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-10-12 23:15:27 Duration: 5s602ms 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-10-12 23:33:53 Duration: 5s246ms 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 2m49s 9m59s 6m39s 3 19m58s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 12 05 3 19m58s 6m39s [ User: intelifix - Total duration: 19m58s - Times executed: 3 ]
[ Application: psql - Total duration: 19m58s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-10-12 05:10:00 Duration: 9m59s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-10-12 05:17:09 Duration: 7m8s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-10-12 05:19:59 Duration: 2m49s Database: contagem User: intelifix Remote: [local] Application: psql
2 2s137ms 8m57s 1m58s 48 1h34m50s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 12 07 3 9m44s 3m14s 08 3 5m22s 1m47s 09 3 5m16s 1m45s 10 3 5m23s 1m47s 11 3 5m33s 1m51s 12 3 5m19s 1m46s 13 3 5m21s 1m47s 14 3 5m26s 1m48s 15 3 5m23s 1m47s 16 3 5m25s 1m48s 17 3 5m31s 1m50s 18 3 5m22s 1m47s 19 3 5m22s 1m47s 20 3 8m14s 2m44s 21 3 6m35s 2m11s 22 3 5m28s 1m49s [ User: intelifix - Total duration: 1h34m50s - Times executed: 48 ]
[ Application: psql - Total duration: 1h34m50s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-12 07:13:59 Duration: 8m57s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-12 20:12:38 Duration: 7m36s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-12 21:11:19 Duration: 6m17s Database: rio User: intelifix Remote: [local] Application: psql
3 229ms 3m46s 1m23s 47 1h5m37s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 12 07 3 5m29s 1m49s 08 3 3m51s 1m17s 09 3 3m50s 1m16s 10 3 3m49s 1m16s 11 3 3m54s 1m18s 12 3 3m50s 1m16s 13 3 3m55s 1m18s 14 3 3m50s 1m16s 15 3 3m54s 1m18s 16 3 4m3s 1m21s 17 3 3m53s 1m17s 18 3 3m53s 1m17s 19 3 3m53s 1m17s 20 2 5m30s 2m45s 21 3 3m54s 1m18s 22 3 4m3s 1m21s [ User: intelifix - Total duration: 1h5m37s - Times executed: 47 ]
[ Application: psql - Total duration: 1h5m37s - Times executed: 47 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-12 07:20:05 Duration: 3m46s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-12 20:18:38 Duration: 3m39s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-12 16:14:28 Duration: 3m34s Database: brasilia User: intelifix Remote: [local] Application: psql
4 1m23s 1m23s 1m23s 1 1m23s refresh materialized view concurrently rs_mv_codigos_barra;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 12 05 1 1m23s 1m23s [ User: intelifix - Total duration: 1m23s - Times executed: 1 ]
[ Application: psql - Total duration: 1m23s - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-10-12 05:32:04 Duration: 1m23s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-10-12 05:31:55 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
5 39s595ms 39s595ms 39s595ms 1 39s595ms refresh materialized view concurrently rs_mv_equipamentos;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 12 05 1 39s595ms 39s595ms [ User: intelifix - Total duration: 39s595ms - Times executed: 1 ]
[ Application: psql - Total duration: 39s595ms - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-10-12 05:30:41 Duration: 39s595ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-10-12 05:30:37 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
6 4s329ms 1m4s 34s12ms 4 2m16s 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 Oct 12 20 2 1m8s 34s400ms 23 2 1m7s 33s624ms [ User: intelifix - Total duration: 2m16s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m16s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-10-12 20:08:47 Duration: 1m4s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-10-12 23:16:42 Duration: 1m2s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-10-12 20:10:47 Duration: 4s484ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
7 343ms 54s30ms 27s51ms 4 1m48s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Oct 12 20 2 54s382ms 27s191ms 23 2 53s824ms 26s912ms [ User: intelifix - Total duration: 1m48s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m48s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-10-12 20:05:47 Duration: 54s30ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-10-12 23:13:45 Duration: 53s481ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-10-12 20:10:12 Duration: 351ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
8 3s332ms 40s786ms 18s296ms 6 1m49s 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 Oct 12 20 3 54s851ms 18s283ms 23 3 54s927ms 18s309ms [ User: intelifix - Total duration: 1m49s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m49s - Times executed: 6 ]
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-10-12 20:06:30 Duration: 40s786ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-10-12 23:14:28 Duration: 40s591ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-10-12 20:10:23 Duration: 10s731ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
9 2s327ms 32s841ms 14s146ms 6 1m24s copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Oct 12 20 3 42s959ms 14s319ms 23 3 41s917ms 13s972ms [ User: intelifix - Total duration: 1m24s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m24s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-10-12 20:07:06 Duration: 32s841ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-10-12 23:15:03 Duration: 31s720ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-10-12 23:33:43 Duration: 7s868ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
10 4s302ms 23s742ms 14s20ms 4 56s83ms 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 Oct 12 20 2 28s104ms 14s52ms 23 2 27s979ms 13s989ms [ User: intelifix - Total duration: 56s83ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 56s83ms - Times executed: 4 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-10-12 20:04:53 Duration: 23s742ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-10-12 23:12:52 Duration: 23s676ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-10-12 20:10:12 Duration: 4s362ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
11 3s1ms 32s130ms 13s940ms 6 1m23s copy public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 12 20 3 42s5ms 14s1ms 23 3 41s635ms 13s878ms [ User: intelifix - Total duration: 1m23s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m23s - Times executed: 6 ]
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-10-12 20:09:19 Duration: 32s130ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-10-12 23:17:14 Duration: 32s60ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-10-12 20:10:54 Duration: 6s655ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
12 2s516ms 24s70ms 12s75ms 6 1m12s copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 12 20 3 36s442ms 12s147ms 23 3 36s7ms 12s2ms [ User: intelifix - Total duration: 1m12s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m12s - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-10-12 20:02:48 Duration: 24s70ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-10-12 23:10:48 Duration: 23s665ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-10-12 23:32:52 Duration: 9s825ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
13 2s257ms 24s357ms 11s978ms 6 1m11s copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 12 20 3 36s32ms 12s10ms 23 3 35s836ms 11s945ms [ User: intelifix - Total duration: 1m11s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m11s - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-10-12 20:03:30 Duration: 24s357ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-10-12 23:11:29 Duration: 24s304ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-10-12 23:33:04 Duration: 9s274ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
14 1s759ms 25s917ms 10s867ms 6 1m5s copy public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Oct 12 20 3 32s740ms 10s913ms 23 3 32s466ms 10s822ms [ User: intelifix - Total duration: 1m5s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m5s - Times executed: 6 ]
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-10-12 20:04:30 Duration: 25s917ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-10-12 23:12:28 Duration: 25s387ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-10-12 23:33:19 Duration: 5s277ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
15 5s756ms 14s827ms 10s595ms 6 1m3s call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 12 00 3 37s929ms 12s643ms 06 3 25s643ms 8s547ms [ User: intelifix - Total duration: 1m3s - Times executed: 6 ]
[ Application: psql - Total duration: 1m3s - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-10-12 00:05:29 Duration: 14s827ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-10-12 00:05:14 Duration: 13s98ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-10-12 06:05:21 Duration: 11s133ms Database: brasilia User: intelifix Remote: [local] Application: psql
16 1s835ms 16s854ms 8s618ms 6 51s712ms copy public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 12 20 3 26s20ms 8s673ms 23 3 25s692ms 8s564ms [ User: intelifix - Total duration: 51s712ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 51s712ms - Times executed: 6 ]
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-10-12 20:03:47 Duration: 16s854ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-10-12 23:11:46 Duration: 16s661ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-10-12 20:09:59 Duration: 7s221ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
17 1s30ms 17s360ms 6s949ms 6 41s694ms 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 Oct 12 20 3 21s48ms 7s16ms 23 3 20s646ms 6s882ms [ User: intelifix - Total duration: 41s694ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 41s694ms - 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-10-12 20:03:05 Duration: 17s360ms 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-10-12 23:11:05 Duration: 16s828ms 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-10-12 23:32:55 Duration: 2s753ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
18 902ms 12s730ms 4s892ms 6 29s355ms 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 Oct 12 20 3 14s777ms 4s925ms 23 3 14s577ms 4s859ms [ User: intelifix - Total duration: 29s355ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 29s355ms - 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-10-12 20:04:04 Duration: 12s730ms 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-10-12 23:12:03 Duration: 12s674ms 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-10-12 20:10:02 Duration: 1s119ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
19 2s941ms 5s753ms 4s621ms 6 27s728ms 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 Oct 12 20 3 13s937ms 4s645ms 23 3 13s791ms 4s597ms [ User: intelifix - Total duration: 27s728ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 27s728ms - 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-10-12 20:07:30 Duration: 5s753ms 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-10-12 23:15:27 Duration: 5s602ms 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-10-12 23:33:53 Duration: 5s246ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
20 305ms 5s159ms 2s497ms 8 19s983ms select * from rs_auditor_novas_tabelas ();Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 12 00 4 10s525ms 2s631ms 06 4 9s457ms 2s364ms [ User: lenon - Total duration: 19s983ms - Times executed: 8 ]
[ Application: psql - Total duration: 19s983ms - Times executed: 8 ]
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-10-12 00:02:07 Duration: 5s159ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-10-12 06:02:06 Duration: 5s56ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-10-12 00:02:11 Duration: 3s794ms Database: brasilia User: lenon Remote: [local] Application: psql
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 10 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Oct 12 08 1 0ms 0ms 09 1 0ms 0ms 11 2 0ms 0ms 12 2 0ms 0ms 13 1 0ms 0ms 16 1 0ms 0ms 17 1 0ms 0ms 20 1 0ms 0ms [ User: intelifix - Total duration: 1m5s - Times executed: 10 ]
[ Application: psql - Total duration: 1m5s - Times executed: 10 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 1,822 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 28 FATAL entries
- 4 ERROR entries
- 0 WARNING entries
- 1 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 18 Max number of times the same event was reported
- 33 Total events found
Rank Times reported Error 1 18 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Oct 12 00 1 01 2 03 1 04 3 07 2 09 3 10 2 11 1 18 2 21 1 - FATAL: database "jaboatao" does not exist
- FATAL: database "jaboatao" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-10-12 00:42:34 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
Date: 2026-10-12 01:29:45 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
Date: 2026-10-12 01:30:01 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
2 6 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #2
Day Hour Count Oct 12 03 6 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-10-12 03:05:01 Database: testes Application: [unknown] User: intelifix Remote: [local]
Context: PL/pgSQL expression "RS_PARAMETRO( 'FORMATO_HORA' )" PL/pgSQL function rs_formato_hora() line 17 during statement block local variable initialization PL/pgSQL function rs_formato_data_hora() line 18 at RETURN PL/pgSQL function rs_giga_triagem(character varying) line 26 during statement block local variable initialization
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-10-12 03:05:01 Database: rio Application: psql User: intelifix Remote: [local]
Date: 2026-10-12 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local]
3 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #3
Day Hour Count Oct 12 05 4 - ERROR: relation "rs_mv_equipamentos" does not exist
- ERROR: relation "rs_mv_codigos_barra" does not exist
- ERROR: relation "rs_mv_equipamentos" does not exist
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-10-12 05:32:04 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-10-12 05:32:04 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-10-12 05:32:04 Database: contagem Application: psql User: intelifix Remote: [local]
4 2 FATAL: database "..." does not exist /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(
Times Reported Most Frequent Error / Event #4
Day Hour Count Oct 12 12 1 13 1 - FATAL: database "jaboatao" does not exist /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(
- FATAL: database "jaboatao" does not exist /usr/lib/python3.9/site-packages/urllib3/connectionpool.py:1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/latest/advanced-usage.html#ssl-warnings warnings.warn(
Date: 2026-10-12 12:59:34 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
Date: 2026-10-12 13:36:39 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
5 2 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #5
Day Hour Count Oct 12 03 2 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-10-12 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-10-12 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local]
6 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #6
Day Hour Count Oct 12 03 1 - LOG: database system was shut down at 2026-10-12 03:05:01 -03
Date: 2026-10-12 03:05:02